Subject Re: [firebird-support] database growing too much after bulk import
Author Ann W. Harrison
Sergio H. Gonzalez wrote:
>
> I have this database:
> ...
>
>
> 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:
>
...
>
> 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 !.
>
> Just in case: After the import I'm doing a backup/restore to make sure there's
> no non used space in my DB.
>

The gstat utility will explain space utilization in your database.

gstat -a -r >SpaceUsed.txt

Cheers,

Ann