Subject | Re: [firebird-support] Slow table after many updates |
---|---|
Author | Alexandre Benson Smith |
Post date | 2005-12-16T21:18:44Z |
rejanemyszka2002 wrote:
You do 1 million updates i a single transaction ?
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
>Hello all!I don't get the picture :-(
>
>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
>
>
You do 1 million updates i a single transaction ?
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br