SlowDataRead

Posts   
 
    
ErinaG
User
Posts: 24
Joined: 31-Dec-2014
# Posted on: 01-Nov-2024 14:25:30   

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
ErinaG
User
Posts: 24
Joined: 31-Dec-2014
# Posted on: 01-Nov-2024 20:05:55   

I found the issue - it was in one of our type converters