Subject Re: [firebird-support] Garbage clean
Author Ann W. Harrison
>I wrote
> > >the next transaction
> > > that encounters the deleted record will remove it.

>Valdir Stiebe Junior wrote:
>How much time (average) the next transaction will use for removing the record?

Ah. That's the hard question. The answer is that in superserver 1.5, the
next transaction won't actually do the garbage collection. It asks a
garbage collect thread to add that record to its list of work. The work
itself may be nearly instantaneous (record all on one page with no back
versions and no indexes) or mind-numbingly slow (record with back versions,
indexes with lots duplicates).