|Subject||RE: [firebird-support] MASSIVE DELETIONS|
> -----Original Message-----I think a lot depends on how massive the deletion. If I need to keep a
> From: firstname.lastname@example.org
> [mailto:email@example.com] 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 ?
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.