Subject Re: Database Size problem?? Please Help
Author Ali Gökçen
Hi,
the default database property of sweep interval:20000 is too much i
think for small applications.
database size is growing until become transaction interval 20000.
try to use a less value after restore, dependet your transaction
increasing speed. it may help.

Ali

--- In firebird-support@yahoogroups.com, "a07272" <a07272@y...>
wrote:
>
>
> Dear All
>
> I am currently doing a number pattern analyzing program. I use
Firebird
> as my database, Delphi as my dev. tool.
>
> I use only 3 table, and no more then 10000 rows of data. Each data
is
> less then 200 byte.
>
> But after program finish, the database it grow to 202MB . Then I
> backup the database, it shink back to 56KB. Can anyone tell me
what's
> happening? Or anyway I can keep the database size as small as
possible.
> Thanks...