On 20 Apr 2004 at 13:34, Epstein, Ed wrote:

>Just out of curiosity, if not FB, what DB can handle tens of millions of
>records with millions of updates per transaction? Or is it just a matter of
>resources available to FB, like 16 GIGS of memory and faster processors.

Probably, FB can handle updates in big table, but you have to do
some things.

1. Minimize number of non-unique indices on the table (or deactivate
them before processing);
2. _Do not_ update the same row twice;
3. Upgrade to FB1.5.

SY, Dimitry Sibiryakov.