Subject Re: [firebird-support] Sweep Interval
Author Rohit Gupta

thanks for your explanation. we were under many delusions..., all
clarified now.

1. select statements constituted readonly transactions
2. select statements did not contribute to the OAT/OIT.
3. autocommit did hardcommit

We were using autocommit only for tables/queries that did not perform
any writes. We have now proved in a sample application that redoing
this fixes the problem that was leading to the slowdown.