Subject Grave problems with a big table
Author Lele Gaifax
Hi all,

I'm hitting a problem with Firebird that I'm not able to solve nor to
understand its nature.

I have a moderately sized DB (~ 650Mb), that contains in particular one
big table with more than 1,200,000 (~ 300 Mb) records. Any operation on it
takes forever to complete... Almost everything was tried, from gfix (that
does not complain at all), to sweep/backup/restore, but none of them
reached an and after a day! Operating on all other tables seems working
well...

So, I tried to pump the big table into a clean db, but after that, the new
DB becomes unusable as well (... as bad!)

Is there anything I can inspect to understand what is going on?

thank you in advance,
bye, lele.