Subject | Re: How to keep fdb file small size |
---|---|
Author | nenhumpois |
Post date | 2013-01-21T08:39:59Z |
Yes it is a big size because the corresponding data is not that much. After backup and restore, the size decreased to 4.7Mb.
Making backup and restore is not pratical for everyday running databases. How to erase the unused bytes?
Making backup and restore is not pratical for everyday running databases. How to erase the unused bytes?
--- In firebird-support@yahoogroups.com, Dmitry Kuzmenko wrote:
>
> 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
>