Subject | Grave problems with a big table |
---|---|
Author | Lele Gaifax |
Post date | 2002-02-26T18:28:41Z |
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.
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.