Subject | Re: [firebird-support] How to keep fdb file small size |
---|---|
Author | Dmitry Kuzmenko |
Post date | 2013-01-14T14:34:55Z |
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
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