[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: 8 hours tests ends with inconsistent DB.

"Kurt D. Zeilenga" <Kurt@OpenLDAP.org> writes:

> At 08:26 AM 6/13/2004, Dieter Kluenter wrote:
>>you should add
>>set_flags DB_TXN_NOSYNC
>>when doing extensive write sessions. 
>
> This, I think, is bad advice.  Disabling sync (and logging)
> is only appropriate where the administrator is willing
> and able to live with the loss of ACID (Atomicity,
> Consistency, Isolation, Durability) properties for
> that session. -- Kurt 

I fully agree if a production environmnt would be discussed, but I
found that server load is substantially reduced while adding and
deleting large numbers in a test setup with syncronizing and logging
disabled. 

-Dieter

-- 
Dieter Klünter | Systemberatung
Tel.: +49.40.64861967
Fax : +49.40.64891521
http://www.avci.de