Subject | Re: Odp: [firebird-support] Readcomitted ReadOnly Transaction - Commit or Rollback? |
---|---|
Author | Ann Harrison |
Post date | 2014-03-01T20:55:57Z |
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 sameresults as a series of short RC/RO transactions, and that the former is moreefficient than the later. On the other hand, if you have to run very shorttransactions, aren't the RC/RO variety cheaper than the alternatives?Cheers,Ann