Subject RE: [firebird-support] over-sweeping??
Author Alan McDonald
> At 10:28 PM 8/03/2004 +0000, you wrote:
> >Can anyone give me a definitive answer to this one: is it possible to
> >'over-sweep' a database? Will there be a performance penalty
> from sweeping
> >(say) each night?? Obviously it will slow the system while sweep takes
> >place. But at 3am I don't care about this.
> >
> >My position is that sweeping can't do any harm, provided the system is
> >quiet at the time. However, someone had suggested to me that *any*
> >sweeping is a bad idea,
>
> Regular sweeping - especially at 3 a.m. - is a very, very good idea.
>
> >and can degrade server performance, even when the sweep is completed.
>
> Not a word of truth in it. If you don't sweep, then there are some
> garbages around the database that won't get cleared at all. After the
> sweep, all is sweet, nothing left.
>

Helen,
if that's correct, then, maybe the manual, which has had this information in
it since I can remember (maybe 1994) should finally be corrected and have it
removed?
Alan