Subject | Re: [ib-support] Bulk Deletes and Inserts |
---|---|
Author | Ivan Prenosil |
Post date | 2001-10-02T17:05:44Z |
> I have a program which nightly copies a dBase database into anIf you are deleting all data from the database, then the fastest way is
> 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.
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