| Subject | Odp: [firebird-support] Readcomitted ReadOnly Tr ansaction - Commit or Rollback? |
|---|---|
| Author | liviuslivius@poczta.onet.pl |
| Post date | 2014-03-01T15:54:27Z |
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
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
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" <dimitr@...>
Do: <firebird-support@yahoogroups.com>
Temat: Odp: [firebird-support] Readcomitted ReadOnly Transaction - Commit or Rollback?
Data: pt., lut 28, 2014 21:34
Od: "Dmitry Yemanov" <dimitr@...>
Do: <firebird-support@yahoogroups.com>
Temat: Odp: [firebird-support] Readcomitted ReadOnly Transaction - Commit or Rollback?
Data: pt., lut 28, 2014 21:34
01.03.2014 00:14, liviuslivius@... wrote:
>Maybe. Although I'm not 100% sure this is doable.
> >> 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?
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