Subject Re: [firebird-support] Re: total records and total versions bigger than expected
Author Ann W. Harrison
Juan Jose Ochoa wrote:
>
> 1. Can the rows marked as deleted make the selection of records
> slower.

Somewhat. They take up space on pages and reduce the record density,
and cause garbage collection.


> 2. How can I know who own the transaction (or the transaction number)
> that has been around for a while?

That we don't handle well, especially in SuperServer.

> 3. Can I use gfix -commit (somehow) from my pc to solve this
> situation?

No, that works only for transactions that are stuck half-way through a
two-phase commit.

Regards,


Ann