Subject Re: [firebird-support] Re: Restart fixes performance issues
Author Ann W. Harrison
rodrigogoncalves wrote:
> What I don't understand
> is why there is a performance issue when an CommitRetaining is applied.
> Since the comands related to the transaction won't be "rollbacked"
> anymore, other transaction have no interest on this one anymore, so
> they should not have a performance impact.

The problem is that a commit retaining starts a new transaction that
keeps the same context as the one that was "commit retained". From
the point of view of garbage collection, it's as if that transaction
were still running, and it block garbage collection at the state when
the original transaction started.