Re: OpenLDAP-2.2.3beta slapdadd slow

[Dieter Kluenter <dieter@dkluenter.de>]

"Jong" <jongchoi@OpenLDAP.org> writes:

>> Hi,
>> 
>> OpenLDAP- 2.1.19
>> BerkeleyDB.4.1.25
>> cyrus-sasl-2.1.12
>> marin:/usr/local/sbin # time ./slapadd -b o=avci,c=de -l /tmp/avci.ldif
>> real    3m43.757s
>> user    2m53.810s
>> sys     0m19.920s
>> 
>> OpenLDAP-2.2.3beta
>> BerkeleyDB.4.2.52
>> cyrus-sasl-2.1.17
>> orange:/usr/local/sbin # time ./slapadd -b o=avci,c=de -l /tmp/avci.ldif
>> real    15m17.371s
>> user    3m4.379s
>> sys     0m15.403s
>> 
>> same avci.ldif with some 5,000 entries

in fact these are 30,000 entries

>> identical DB_CONFIG

set_cachesize 0 1048576 1
set_flags DB_TXN_NOSYNC

>> backend bdb
>> filesystem reiserfs
>> identical hosts
[...]
> It would be interesting to see the time with an increased dbcachesize value.
> It might be true that that BDB-4.2 use more pages internally...

I have doubled cachsize in DB_CONFIG
set_cachesize 0 2097152 1
set_flags DBTXN_NOSYNC

orange:/usr/local/sbin # time ./slapadd -b o=avci,c=de -l /tmp/avci.ldif 
real    8m7.305s
user    3m47.985s
sys     0m15.956s


-Dieter

-- 
Dieter Kluenter  | Systemberatung
Tel:040.64861967 | Fax: 040.64891521
mailto: dkluenter(at)dkluenter.de
http://www.avci.de