Subject | Re: Odp: [firebird-support] Readcomitted ReadOnly Transaction - Commit or Rollback? |
---|---|
Author | Carlos H. Cantu |
Post date | 2014-02-28T20:59:02Z |
IMHO, RC+RO should be used mostly for long running transactions, since
its major benefit is to not block garbage collection. I usually use
them for "lookup" data.
I agree with Dmitry that constantly commiting such transactions is
kind of nonsense or misuse of its purpose, unless there is some
specific situation that could justify such behavior (and I'm not
seeing it).
Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br
DY> 01.03.2014 00:14, liviuslivius@... wrote:
DY> And anyway, I feel a big problem for applications committing RC RO txns
DY> so much often that it could possibly affect the performance. This sounds
DY> like a feature misuse.
DY> Dmitry
its major benefit is to not block garbage collection. I usually use
them for "lookup" data.
I agree with Dmitry that constantly commiting such transactions is
kind of nonsense or misuse of its purpose, unless there is some
specific situation that could justify such behavior (and I'm not
seeing it).
Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br
DY> 01.03.2014 00:14, liviuslivius@... wrote:
>>DY> 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?
DY> And anyway, I feel a big problem for applications committing RC RO txns
DY> so much often that it could possibly affect the performance. This sounds
DY> like a feature misuse.
DY> Dmitry