Subject Re: [firebird-support] Question about delay in fetch operation
Author John vdW
Op 28-01-2019 om 14:14 schreef Rudi Feijó rudi.feijo@... [firebird-support]:

>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

Hi Rudi,

Have you tried the same query with isql ?

(Just to rule out a possible problem at clientside)