Re: OpenLDAP performance vs. PostgreSQL

[Pierangelo Masarati <ando@sys-net.it>]

On Wed, 2006-03-15 at 17:32 +0200, Buchan Milne wrote:

> With single-bind many-queries, results of over 20 000 searches/second are 
> possible (on indexed attributes) without too much tuning on reasonable (ie 
> dual 3 GHz Xeon) hardware.
> 
> So, I suspect you have missed some tuning, most likely you have no DB_CONFIG 
> file in your database directory, or it is inadequately tuned.
> 
> More information (ie slapd.conf extracts, log extracts, DB_CONFIG file etc) 
> would help ...

Typical rates on a well-tuned large (>100000 entries) back-bdb instance
on a reasonably performing hardware (4 Xeon 3.16 GHz, 1Gb switch, 50MB/s
disk read, 1500 MB/s ram read: >20000 random search/s (single bind,
fully indexed, adequate cache & idl cache size).

On my laptop, without significant tuning: 10000 entries loaded at 940/s
with slapadd -q; at 178/s with ldapadd (full indexing).

I'd note that OpenLDAP 2.2.23 is not the latest (or by any means a
recommended) version.

p.




Ing. Pierangelo Masarati
Responsabile Open Solution
OpenLDAP Core Team

SysNet s.n.c.
Via Dossi, 8 - 27100 Pavia - ITALIA
http://www.sys-net.it
------------------------------------------
Office:   +39.02.23998309          
Mobile:   +39.333.4963172
Email:    pierangelo.masarati@sys-net.it
------------------------------------------