Subject Re: [firebird-support] DELETE - but database file size remains - what do I do wrong?
Author Martijn Tonies
Hello Thomas,

> when I delete e.g. 200 MB of data from a 400 MB database file, I can
> confirm (using IBO Console) that the data has actually dissapeared
> from the tables but the size fo the database file on disk is still
> 400 MB? What do I do wrong --> I fear that I do something very
> unpleasant to the garbage collection mechanism? I use D7 (IBX) and
> embedded server v1.5.1... and I don't understand, since I obviously
> close the delete transaction correctly or otherwise the data would
> not dissapear from the table? Why does the garbage collection not
> decrease the size of the DB file when I disconnect from the DB?

Not to worry - the emptied space will be re-used for new data.

The reason is, that file size cannot be decreased, only increased.

If you really want to get a smaller file, you need to backup the
database and restore it.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions