Subject Re: [firebird-support] garbage collection
Author Ann W. Harrison
Puigsegur, Jordi wrote:
> I wonder if is it really necessary / useful to run a gfix -sweep? Maybe
> after a massive deletion or insertion of records ?
>

That's application dependent. If you normally store records in
ascending order by a key value and deleted the oldest records
by the same key value and very seldom do a full table scan, the
old records won't be revisited and garbage collected automatically,
so you should sweep or run gbak periodically.

If your data is more random, then no, you don't need to do anything
special.


Regards,


Ann