Hi, 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. Regards, Karol Bieniaszewski Regards, Karol Bieniaszewski ----- Reply message ----- Od: "Dmitry Yemanov" <[email protected]> Do: <[email protected]> Temat: Odp: [firebird-support] Readcomitted ReadOnly Transaction - Commit or Rollback? Data: pt., lut 28, 2014 21:34 01.03.2014 00:14, [email protected] 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. Dmitry
