|Subject||Re: how to "Clean up" database|
> Newbie question:Do you mean 20GB? 20MB is definitely not large. Our 500MB databases
> I added a large number of records to a db making it's file size 20mb.
are relatively small.
> Then I delete all records, and size remains unchanged.You don't. Firebird will automatically reuse the space when no
> How does one therefore remove the stale records?
concurrent transaction can be interested in the deleted records.
To explain why deleted records must be retained for a while:
To explain why Firebird doesn't return the unused space to the OS when
it finally can: