--- In firebird-support@yahoogroups.com, "Adam" <s3057043@...> wrote:

>
>
> > Cool! I added manual sweep to run everyday. Is the frequency fine?
>
> Hi Sean,
>
> It is a bit like me asking you "I fill my car with petrol every day.
> Is that fine?" You would reply "that depends on how far you drive

daily".

>
> For a lot of databases, a daily sweep is overkill. For some, it is
> necessary. It just depends on how many transactions you have per day,
> and how much garbage accumulates through those transactions.
>
> Adam
>

I agree. Our deployment may have 1 client application or up to 1000
client apps to inject data into the database, so I guess it's hard to
decide a general time-interval...