> 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

be careful how you interpret the sweep interval. It does not refer to the
gap between the "first" and "last" transaction.
I have applications such that even if I had set sweep to 20, the sweep would
never be activated. Please read the confusing documentation on just when a
sweep is activated.

Alan

>
> --- 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...
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>