LLBLGen 5.8.3
ORM Profiler v2.0.1
I'm running into a strange performance issue.
I'm running a search query and it works fine/fast on my primary test database, but it's super slow (100+ sec) on a secondary test database.
Both databases have similar sized datasets.
Using ORM Profiler, I've found that the actual SQL query itself is fine - fast on both databases, but on the slow one I get this "SlowDataRead" alert.
I'm fetching the same dataset from both databases, which is only a couple strings, ids, and timestamps (no CLOBs/BLOBs) and I've set the same "max records to return" for both, so they're both returning the same number of records.
So I'm stumped as to why the data read would be slow for one but not the other.
Any ideas?
Attachments
Filename |
File size |
Added on |
Approval |
image (3).png
|
66,822 |
01-Nov-2024 14:25.55 |
Approved |