Subject Re: [ib-support] Bulk Deletes and Inserts
Author Ivan Prenosil
> I have a program which nightly copies a dBase database into an
> Interbase database for reporting purposes. The program operates as
> follows for each table.
>
> Disable all indexes.
> Delete all records (delete from tablename).
> Insert all records from the dBase tables (commit every 1000 records).
> Activate all indexes.

If you are deleting all data from the database, then the fastest way is
Drop the database.
Create new database (just copy already prepared empty one with inactive indexes).
Insert all records from the dBase tables (commit every 1000 records).
Activate all indexes.

Ivan
http://www.volny.cz/iprenosil/interbase