Subject Re: [firebird-support] Readcomitted ReadOnly Transaction - Commit or Rollback?
Author Ann Harrison
> On Feb 27, 2014, at 4:57 AM, Ralf Jansen <ralf.jansen@...> wrote:
> Hi Karol,
>> Do you have only on test env. 400 transactions per second or it will be also near number on real env?
> That’s was just for my test environment. But we have a few customers that reach counter limit in the real product in a year or so if they don't backup/restore.

I'm confused. I thought that read-only read-committed transactions did not consume transaction ids. By nature they don't need the protection of the transactional system. They don't make changes so there's no need to roll back. Nor is there any need to prevent others from reading their uncommitted changes. They don't offer consistent reads, so they don't need to prevent garbage collection. Why do they need unique transaction identifiers?

best regards,