Lele:

Can you tell us how do you use to access this DB? What kind of operations
are you complain? Inserting a record using IBConsole, for example, will be a
problem? If the problem is querying that table, could you tell what the plan
is?

With your information no one will be able to help you.

Artur

----- Original Message -----
From: "Lele Gaifax" <lele@...>
Newsgroups: egroups.ib-support
To: <ib-support@yahoogroups.com>
Sent: Tuesday, February 26, 2002 6:28 PM
Subject: [ib-support] Grave problems with a big table


> 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.
>