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 - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php