> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.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 ?

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.