Subject Re: [firebird-support] Oldest snapshot never moves slowing system down dramatically!
Author Lester Caine
robert.gilland wrote:
> I am using Firebird 2.1.3
> I seem to be doing every thing correctly.
> Start transaction then commit it.
> But the oldest snapshot transaction never moves and after not long the system slows down dramatically what can I do?

What are you using to check the oldest transaction number?
Leaving a connection attached that has a transaction open will cause the
problem, even if your actual application is working properly, and 'watching'
from another application such as FlameRobin can do that.

Lester Caine - G8HFL
Contact -
L.S.Caine Electronic Services -
EnquirySolve -
Model Engineers Digital Workshop -
Firebird -