I think that the index attributes are the most important
determinant of performance for this application.
I use BSD 4.4 DB, with B-tree indices on the key array.
My operating platform is Solaris 2.5, (Ross 166 MHZ Sparc, 128 MB core)
51,000 entries - using attributes similar to the 'umichPerson'
objectclass. Queries are blazingly fast (under a second, using
the last name). Inserts and updates average about 1.5 seconds
per entry.
When I get time someday, I'd like to build a test-suite to
query the database randomly with concurrent connections.
I also have data generated by our existing Ph/CSO driven mail-server
(phquery) to hot-test the LDAP server with real-world data.
If anyone is interested, I have built tools that will allow you
to easily migrate/synchronize your existing CSO database to SLAPD.
It uses mSQL as a intermediate stage to warehouse the data and
convert it into LDIF.
Anyways, My database looks like this:
------------------------------------------------------------------
index cn
index sn eq,sub,approx
index default none
------------------------------------------------------------------
total 136290
-rw-r--r-- 1 root other 6 Aug 5 03:21 NEXTID
-rw-r--r-- 1 root other 0 Aug 5 03:21 TEST.tlog.lock
-rw------- 1 root other 18358272 Aug 5 15:57 cn.dbb
-rw------- 1 root other 12673024 Aug 5 03:21 dn.dbb
-rw------- 1 root other 5382144 Aug 8 10:26 dn2id.dbb
-rw------- 1 root other 65536 Aug 4 12:59 id2children.dbb
-rw------- 1 root other 23429120 Aug 5 03:21 id2entry.dbb
-rw------- 1 root other 98304 Aug 4 12:59 objectclass.dbb
-rw------- 1 root other 5988352 Aug 8 10:26 sn.dbb
-- Jim
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
Jim Doyle Boston University Information Technology
Systems Analyst/Programmer Distributed Systems Group tel: 617-353-8248
"UNIX for a stronger America" email: jrd@bu.edu fax: 617-353-6260
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-++--+-+-+-+-+-+-