Subject Re: [firebird-support] FB 2.5.8 - Next transaction value growing too much.
Author Dimitry Sibiryakov
01.07.2019 18:11, duque.hernando@... [firebird-support] wrote:
> What am I doing wrong?

You misunderstood documentation. Sweep does move OAT (and collect garbage as a side
effect), but it has nothing to do with Next Transaction.
Numbers from your gstat output tell that your application has a bad transaction
management: it either starts too much unnecessary transactions or keep them alive longer
than necessary.
I'd suggest read the Firebird Book by Helen Borrie where these things are explained in
details.


--
WBR, SD.