Puigsegur, Jordi wrote:

>
> Which is the best way to perform a massive deletion on a table with
> million of rows ?
>
> In other environments we first perfom a select to gather the dbkeys of
> the records to be deleted and then delete them performing commits every
> n records. Is there something similar in Firebird ?
>

What really helps with massive deletions (before Firebird 2.0) is
dropping the indexes first. I doubt that selecting db-keys first
then deleting records will help much, if at all.


Regards,


Ann