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
backup/restore.

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 http://www.firebirdsql.org and click the Resources item
NPe> on the main (top) menu. Try Knowledgebase and FAQ links !

NPe> Also search the knowledgebases at http://www.ibphoenix.com

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






--
Dmitry Kuzmenko, www.ib-aid.com