Something on the middle (driver) are using commit retaining
instead of a hard commit? From the synptoms, could be this.

Em 21/03/2011 04:19, Lester Caine escreveu:

> 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
>
>