>Look at gstat output

>You probably have very long version this particular record

 

Hi Karol.
I checked gstat and made a manual sweep of the database, but the problem 
persists. 
There are some things I’m finding odd :

-The query brings 4791 records total 

-Always on record 4000, it hangs and delays for 15 seconds

-If I manually remove record number 4000, the same thing happens (the “next” 
record 4000 also hangs the query)

-If I limit the query to just one record short of the total, “SELECT FIRST 
4790”, the slow down DOES NOT happen, query runs fine

-I tried, then, removing the last record from the table, so that my new total 
is 4790, but that didn’t work, the unpaginated query still hangs at record 4000

Reply via email to