Unnecessarily growing of database

How do I prevents my database from growing unnecessarily?

Ex. I have a empty database, with 1 table.
Size 1072 kb.

I insert 100.000 rows in the table.
Now the size is 6024 Kb.

Then I delete all rows in the table.
But the database size is still 6024 Kb!!


How do I get the "real" database size, without making a backup/restore?






Database info:
Page size is 8192
Page buffers is 8192
Sweep interval is 2000
Forces Writes = true
Firebird superserver WI-V6.3.1.4481 Firebird 1.5

just try to insert the records again and you will see, that the used space is not lost, because Firebird reuses all empty pages for new data, but it does not free it for OS Usage without backup and restore.

but have a look in the statistics if the garbage collection works properly, otherwise use gfix to sweep the database manually.


Best Regards

Holger Klemt

The most Expert for InterBase and Firebird -www.ibexpert.com
HK Software - Huntestrasse 15 - 26135 Oldenburg - Germany
Phone/Fax +49 700 IBEXPERT (42397378) www.h-k.de
Training and Support for Delphi, InterBase, Firebird, AS/400