Op 28-01-2019 om 14:14 schreef Rudi Feijó [email protected]
[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)
John
