Subject Odp: [firebird-support] Readcomitted ReadOnly Tr ansaction - Commit or Rollback?

Not misuse - if you do not need to change anything you start RO RC transaction. And think about web pages. Ok you can write somethink in the middle but this is some additional work/cost.

I write ticket on tracker few month ago in .net driver to support RORC transaction pooling not only connections.

Karol Bieniaszewski

Karol Bieniaszewski

----- Reply message -----
Od: "Dmitry Yemanov" <dimitr@...>
Do: <>
Temat: Odp: [firebird-support] Readcomitted ReadOnly Transaction - Commit or Rollback?
Data: pt., lut 28, 2014 21:34


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. Dmitry Nice, but it is written to disk
> and maybe it shouldn't?

Maybe. Although I'm not 100% sure this is doable.

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.