Subject Re: [firebird-support] How to keep fdb file small size
Author Dmitry Kuzmenko
Hello, Nenhum!

Monday, January 14, 2013, 6:17:09 PM, you wrote:

NPe> Does anyone knows how to keep the fdb file size small? I created
NPe> a small database and with 15.000 records of small data per record and i get 48Mb size
NPe> for the fdb file.
NPe> Thank you.

Seems that you inserted some data and then deleted it. Database does
not shrink, never.
To see real size of data and indices in your database, make

Also, if you use Firebird 2.5, you may check
#DatabaseGrowthIncrement = 134217728
parameter in the firebird.conf. But anyway, increase goes by 1/16,
and that means, the last increase was made by 6.6mb, and previous size
was 41mb.

btw, is 48mb now is a "big database?"

NPe> ------------------------------------

NPe> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

NPe> Visit and click the Resources item
NPe> on the main (top) menu. Try Knowledgebase and FAQ links !

NPe> Also search the knowledgebases at

NPe> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
NPe> Yahoo! Groups Links

Dmitry Kuzmenko,