>>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 _ John, yes I tried with isql, same behaviour. Im using firebird 3, tried with the latest stable release, and the latest snapshot from today.
