Any uncommitted transactions? Check the OAT (oldest active
transaction) and the next transaction to see if the gap between them
is small or large.

HTH,
Set

--- In firebird-support@yahoogroups.com, Szakály Balázs wrote:
> I always check the active connections on server, when performance is
> poor: 20-30 user.... So, no unclosed session...unfortunately...
>
> Hi, I had a similar problem to yours fairly recently. It was a
> simple oversight on my part and probably not the same as the cause
> of your problem. I was creating a connection in a thread and
> forgeting to close the connection before freeing the thread, so try
> double- checking that all connections are properly closed.
>
> cheers, Terry
>
> --- In firebird-support@yahoogroups.com, Szakály Balázs wrote:
> > Hi!
> >
> > We operate a server somewhere.
> >
> > There are ~10 simle user with ~20 database connection. This users
> > run ~10SQL/minute. (select * from..., update, etc) from a Delphi
> > app.
> > And there is 1 process which use ~10 database connection, and run
> > ~70SQL/minute (50 select and 20 insert)
> >
> > The performance decrease in 3-4 days until a simple select takes 7
> > second (which is othervise ~100msec). Then i restart the server
> > and performance restored.
> >
> > Where i need look for the problem?
> >
> > System: XP prof, Firebird 1.5 Final, Borland DBExpress driver