Subject database size remains constant after deletion of records
Author deepak_cs_mca_2006

I am using Firebird database version 1.5 for storing records. All
the operations (mostly inserts and read)
are working correctly.

My problem is that, when I delete older records (sometimes in a
bulk) from the database to reduce the size of the database,
records get deleted but database size remains the same. Is there a
way to reduce the size of the database after delete operation has
deleted many records.

I tried to call gfix -sweep but the size is still shown to be the

My guess is that garbage collection has happenned with gfix-sweep,
but compression has not taken place.
Is this the correct functionality of gfix-sweep? If it is, then is
there a way that I call compression on the database
file explicitly so that I can reduce the size of the database file
after the gfix-sweep has taken place.

Please help.

Thanx in advance

Deepak Gupta