Subject RE: [firebird-support] MASSIVE DELETIONS
Author Brenden Walker
> -----Original Message-----
> From:
> [] On Behalf Of
> Puigsegur, Jordi
> 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 ?

I think a lot depends on how massive the deletion. If I need to keep a
small percentage of records, I find that copying them to a temporary
table (possibly external) and then dropping/recreating the original
source table works very well. Dropping tables takes hardly any time.