--- In firebird-support@yahoogroups.com, Szakály Balázs
<szakalyb@f...> wrote:

> > Any uncommitted transactions? Check the OAT (oldest active
> > transaction) and the next transaction to see if the gap between

them is small or large.

>
> Oldest transaction 4843280
> Oldest active 4843281
> Oldest snapshot 4843277
> Next transaction 4843656

Looks excellent. You said it is enough to restart server? Looks like
some resource exhaustion. Usually this is memory leak in UDFs. Check
RAM state when performance decreased. If I'm right, start to: connect
- start transaction - call select with UDF 1000 times - commit -
disconnect and watch RAM to find problem UDF.

Best regards,
Alexander.