Subject Re: [firebird-support] Slow table after many updates
Author Alexandre Benson Smith
rejanemyszka2002 wrote:

>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?
I don't get the picture :-(

You do 1 million updates i a single transaction ?

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil