|Subject||Re: [firebird-support] Question about delay in fetch operation|
>Look at gstat output
>You probably have very long version this particular record
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
Have you tried the same query with isql ?
(Just to rule out a possible problem at clientside)