Subject | Re: [firebird-support] garbage collection |
---|---|
Author | Ann W. Harrison |
Post date | 2007-04-13T18:50:24Z |
Puigsegur, Jordi wrote:
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
> I wonder if is it really necessary / useful to run a gfix -sweep? MaybeThat's application dependent. If you normally store records in
> after a massive deletion or insertion of records ?
>
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