Re: slapd - which backend to use?

Jim Doyle (jrd@bu.edu)
Fri, 9 Aug 1996 13:17:37 -0400 (EDT)

On Fri, 9 Aug 1996, Bob Shafer wrote:
> My question is this, is one better than the other? Has anyone looked at the
> relative performance, etc. ?

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
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-++--+-+-+-+-+-+-