You can do a backup followed by a restore using gbak. This will compact the
database.

/Svend

_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of peter_nn0
Sent: 28. december 2007 23:16
To: firebird-support@yahoogroups.com
Subject: [firebird-support] can you "compact" a database ?



Hi,

merry Christmas!

I wonder if it's possible to "compact" a database, in other words to
delete permanently the deleted data.
I have a database ~50MB. After deleting all the entries in most tables,
the database file size is practically the same, while it should be 2MB
at most. This means data is just marked as deleted, but in fact
remains - I'm looking for a way to remove it really.

Thanks.






[Non-text portions of this message have been removed]