Subject | Slow table after many updates |
---|---|
Author | rejanemyszka2002 |
Post date | 2005-12-16T21:14:41Z |
Hello all!
I have a table for control the unique keys (code) of all my tables.
I have been importing data for my database and there are a lot of
updates in a register in this table. +/- 1.000.000 of updates.
After many update this table get slow, very slow. And I can't get a
backup, the backup stop in this table. And is very, very slow to open
the data of this table.
This is a very bad feature of firebird.
What could I do for the table doesn't get slow?
Thanks
[]'s
Rejane
I have a table for control the unique keys (code) of all my tables.
I have been importing data for my database and there are a lot of
updates in a register in this table. +/- 1.000.000 of updates.
After many update this table get slow, very slow. And I can't get a
backup, the backup stop in this table. And is very, very slow to open
the data of this table.
This is a very bad feature of firebird.
What could I do for the table doesn't get slow?
Thanks
[]'s
Rejane