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

BDB 4.2.52 VS BDB 4.4.20 Showdown



The following set of tests were performed on a 2.6.8 kernel Dell 1750 with dual 3GHz CPUs and 2GB RAM. Other than BDB, all versions of the software used were the identical. For this showdown:

BDB 4.2.52 or BDB 4.4.20
Cyrus-SASL 2.1.21
Heimdal 0.7.1
OpenLDAP 2.3.19
OpenSSL 0.9.8a

Test scenarios:
Persistent connection test, returning an entire object (P)
Persistent connection test, returning a single attribute from the object (PA)
Continually reconnecting test, returning an entire object (R)
Continually reconnecting test, returning a single attribute form the object (RA)
Load generator, 30% MOD 70% search (LG1)
Load generator, 50% MOD 50% search (LG2)
Load generator, 70% MOD 30% search (LG3)
MOD test 1, 6 clients 2 threads each from 3 hosts (MOD1)
MOD test 2, 1 client 1 thread 1 host (MOD2)
100k entry DB load, 21 indices, DB Cachesize starved (LOAD1)
100k entry DB load, 3 indices, Plenty of DB Cache (LOAD2)


BDB 4.2.52:
---------------------------------------------------------------------

P    : 8,705 searches/second
PA   : 14,693 searches/second
R    : 1,139 searches/second
RA   : 1,359 searches/second
LG1  : 1,651 operations/second. 495 MOD/second. 1,156 searches/second.
LG2  : 999 operations/second. 500 MOD/second. 499 searches/second.
LG3  : 729 operations/second. 510 MOD/second. 219 searches/second.
MOD1 : 521 MOD/second.
MOD2 : 496 MOD/second.
LOAD1: 3:35.20 total time
LOAD2: 0:34.17 total time


BDB 4.4.20
---------------------------------------------------------------------
P : 8,479 searches/second.
PA : 13,546 searches/second.
R : 1,131 searches/second.
RA : 1,341 searches/second.
LG1 : 3,959 operations/second. 1,187 MOD/second. 2,772 searches/second.
LG2 : 2,656 operations/second. 1,328 MOD/second. 1328 searches/second.
LG3 : 1,983 operations/second. 1,387 MOD/second. 596 searches/second.
MOD1 : 1,398 MOD/second.
MOD2 : 904 MOD/second.
LOAD1: Unable to complete, BDB blows up. Following pre-destruction trend, it would take approximately 4 minutes, 30 seconds to complete.
LOAD2: 0:40.74 total time




Conclusion:
---------------------------------------------------------------------

It looks like BDB 4.4 could become a major boon to OpenLDAP. It is substantially faster than BDB 4.2.52 for write operations occurring inside an existing database. On the downside, it is markedly slower for importing a database via slapadd. It also is slightly slower than 4.2.52 for READ operations, but this slowness is very marginal, especially compared to the gain in WRITE speed.

HOWEVER, there apparently remain some issues either in BDB 4.4.20 or between BDB 4.4 and OpenLDAP that make it unstable and not fit for use at this time with OpenLDAP.

--Quanah

--
Quanah Gibson-Mount
Product Engineer
Symas Corporation
Packaged, certified, and supported LDAP solutions powered by OpenLDAP:
<http://www.symas.com>