Subject | Re: [firebird-support] Re: Restart fixes performance issues |
---|---|
Author | Ann W. Harrison |
Post date | 2005-10-27T14:55:21Z |
rodrigogoncalves wrote:
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.
Regards,
Ann
>The problem is that a commit retaining starts a new transaction that
> 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.
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.
Regards,
Ann