fukura8888 wrote:

> Although I've been deleting quite huge amount of records
> in a firebird database, the size of the database file is
> the same as before.
> This was quite strange to me and looked up the firebird
> manuals but they just recommended only backup/restore.
> Problem is that I gotta periodically delete certain
> amount of records to maintain the appropriate usable disk space.
> I added that code in my .net application but the size of
> the database keep growing although deleted records and
> inserted records are exactly the same.
> Is there any SQL command to clean up the garbage space/data
> rather than backup/restore method?

Why do you call it strange? How would one build a database system that
compacted the remaining records in an efficient manner, esp. in an 7x24
environment?

The garbage will be "collected and removed", i.e. new records will use the
space that now has become free. Backup+restore to compact the database is
not good for anything at all if new records will be added to the
database. (Backup+restore is good for other reasons, evidently)


--
Aage J.