| Subject | Re: [firebird-support] Re: Error code -901 'conv_out_blob_materialized.isc_open_blob2: BLOB not found' |
|---|---|
| Author | Helen Borrie |
| Post date | 2011-01-17T03:14:56Z |
At 10:49 AM 17/01/2011, Aldo Caruso wrote:
./heLen
>Svein,READ_COMMITTED is a transaction isolation level. If you don't have those transactions READ_COMMITTED then they will be SNAPSHOT (a.k.a. Repeatable Read or Concurrency) or SNAPSHOT TABLE STABILITY. In reality, SNAPSHOT TABLE STABILITY is not an option for your purposes. Your alternative is actually READ_ONLY SNAPSHOT, as long as you are willing to commit that transaction regularly to keep the OIT moving.
>
> Thanks for you answer. Following your advice I'll change the mode
>from READ ONLY + READ COMMITTED to READ ONLY of those read only
>transactions which can collide with other transactions that delete or
>update records, and minimize the time they last to avoid server
>performance penalties.
>
>> >Is there any efficiency loss, or some penalty, if you open a
>> >transaction in READ_ONLY mode instead of READ_ONLY + READ_COMMITTED ?
>>
./heLen