Subject Re: Odp: [firebird-support] Readcomitted ReadOnly Transaction - Commit or Rollback?
Author Ann Harrison

On Fri, Feb 28, 2014 at 3:34 PM, Dmitry Yemanov <dimitr@...> wrote:
01.03.2014 00:14, liviuslivius@... wrote:
>
>  >> IIRC, TIP is written only when RC RO txn starts, at this point it
> records its state as committed.

And anyway, I feel a big problem for applications committing RC RO txns
so much often that it could possibly affect the performance. This sounds
like a feature misuse.

I agree that a long running RC/RO transaction produces exactly the same
results as a series of short RC/RO transactions, and that the former is more
efficient than the later.  On the other hand, if you have to run very short 
transactions, aren't the RC/RO variety cheaper than the alternatives?

Cheers,

Ann