Subject Re: [ib-support] Bulk Deletes and Inserts
Author Ann W. Harrison
At 04:35 PM 10/2/2001 +0100, Ian Newby wrote:

>Disable all indexes.
>Delete all records (delete from tablename).
>Insert all records from the dBase tables (commit every 1000 records).
>Activate all indexes.
>If I run the program on an empty Interbase table, the filesize is about
>180mb. If I rerun the program the file size almost doubles.
>I thought that Interbase 6/Firebird 1.0beta automatically reused space
>created by deleted records but this does not seem to be the case.

After you delete all records, commit, then select count (*). That
will release the space. Space is released when an obsolete record
is touched and storing new records doesn't touch old ones.


We have answers.