| Subject | Re: [firebird-support] Re: Performance when deleting a lot of records, again |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2005-04-07T14:21:35Z |
cosamektoo wrote:
tables. A snapshot transaction sees a stable state of the whole
database, so it inhibits garbage collection everywhere.
Regards,
Ann
>Ah! All transactions have to finish, not just the ones that touch those
> One 'DEVICE_FREE_SPACE' - 1455 and STATUS_KEEPER : 103420.(This table
> contains only one record all the time with un integer value).
> I've checked the transactions on those tables and they all commit
> immediately.
tables. A snapshot transaction sees a stable state of the whole
database, so it inhibits garbage collection everywhere.
Regards,
Ann