Subject | Re: [firebird-support] database growing too much after bulk import |
---|---|
Author | Douglas Tosi |
Post date | 2008-11-05T18:27Z |
On Wed, Nov 5, 2008 at 10:06 AM, Sergio H. Gonzalez
<shg_sistemas@...> wrote:
Take a look at parameter named DatabaseGrowthIncrement in firebird.conf.
It may me the source of such a big difference.
hth,
--
Douglas Tosi
www.sinatica.com
<shg_sistemas@...> wrote:
> It has 8,186 KB with some tables filled with some records. After I do an...
> import
> from a DBF table (38.000 records) into this particular table:
>Firebird 2.1 allocates disk space in big chunks to prevent file fragmentation.
> The database grows to 190,416 Kb !!
> Is that normal? The DBF I'm importing it's 10 MB, Of course I know that the
> relation between the DBF size and the growing on my databse may have very
> little
> to do, but I'm very surprised by the new size my DB gets after the import !.
Take a look at parameter named DatabaseGrowthIncrement in firebird.conf.
It may me the source of such a big difference.
hth,
--
Douglas Tosi
www.sinatica.com