We are using Symas OpenLDAP 2.4.12.1 on a  Red Hat EL 5.2 64-bit with 8GB of memory.<br><br>My DB_CONFIG settings are:<br><div style="margin-left: 40px;">set_cachesize 3 0 2<br>set_lk_max_locks   3000<br>set_lk_max_objects 1500<br>
set_lk_max_lockers 1500<br>set_lg_regionmax 262144<br>set_lg_bsize 2097152<br>set_lg_dir /opt/symas/var/openldap-logs/amwater<br>set_flags       DB_LOG_AUTOREMOVE<br>set_tas_spins 1<br><br></div>The 10 million user load finished in about 18 hours. I believe the primary issue is the fact that we have a single disk on the system. I assume that if I were to move the database and log files off to separate disks I would get much better performance.<br>
<br>Thanks,<br>Pete<br><br><br><div class="gmail_quote">On Wed, Mar 18, 2009 at 11:26 PM, Quanah Gibson-Mount <span dir="ltr">&lt;<a href="mailto:quanah@zimbra.com">quanah@zimbra.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im">--On Wednesday, March 18, 2009 1:25 PM -0400 Pete Giesin &lt;<a href="mailto:pgiesin@hubcitymedia.com" target="_blank">pgiesin@hubcitymedia.com</a>&gt; wrote:<br>
<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I am trying to perform some benchmarking against OpenLDAP. So far I have<br>
ran my tests against a 100K and 1Million entry database and I have had<br>
rather decent numbers. My final set of tests were to be ran against a<br>
10Million entry database. Unfortunately, I am having difficult loading<br>
the database with this many entries. I have generated 10 1Million LDIF<br>
files. I am using &quot;slapadd -c -q -v -l &lt;file&gt;&quot; to import each file. The<br>
first 2 files took approximately 15 minutes each to load. The remaining 8<br>
files are taking progressively longer and longer. So much longer that I<br>
anticipate the entire proceess to take well over 24 hours. My question is<br>
is there anything I can do to increase the performance of slapadd. I<br>
assume that since slapd is not running at this point that the normal<br>
DB_CONFIG and slapd.conf settings do not have much affect.<br>
</blockquote>
<br></div>
What are the settings in your DB_CONFIG file?  It is absolutely critical to the performance of slapadd.  What version of OpenLDAP are you using?  What version of BDB?  What operating system?<br>
<br>
--Quanah<br><font color="#888888">
<br>
--<br>
<br>
Quanah Gibson-Mount<br>
Principal Software Engineer<br>
Zimbra, Inc<br>
--------------------<br>
Zimbra ::  the leader in open source messaging and collaboration<br>
</font></blockquote></div><br>