Sponsorships available

Brad Midgley bmidgley at xmission.com
Wed Apr 13 10:05:53 MDT 2005


I'll just pipe in with one more comment.

One reason performance is bad with openldap-sql because they can't 
assume the naming attribute is always the same. It's a very long story.

I made a change to my server to assume a fixed naming attribute. The 
maintainer naturally didn't like it. I should have asked him if he'd 
consider it as a config file option that was "not recommended."

Anyway, it made ldap queries on that fixed naming attribute (uid) go 
from 10 seconds to under 1 second! This is one of several reasons the 
design of ldap does not fit well with sql.


Stuart Jansen wrote:
> On Fri, 2005-03-18 at 17:11 -0700, David Smith wrote:
>>OpenLDAP already does this. It can use PostgreSQL, MySQL, BDB, and many
>>other backends. I'm not sure about the other items on the list, but it
>>might be a good idea to double-check that they don't already exist as
> OpenLDAP can indeed access and SQL backend, but isn't really
> recommended. The tuned BDB based backends are going to give you much
> better performance. Of coure, if it's just for personal use, speed isn't
> likely to matter much.
> ------------------------------------------------------------------------
> .===================================.
> | This has been a P.L.U.G. mailing. |
> |      Don't Fear the Penguin.      |
> |  IRC: #utah at irc.freenode.net   |
> `==================================='

More information about the PLUG mailing list