How does the speed of SQL compare to the speed of LDAP? If the speeds are comparable, why bother with LDAP, which doesn't handle writes very well? Jim C. -- ----------------------------------------------------------------- | I can be reached on the following Instant Messenger services: | |---------------------------------------------------------------| | MSN: j_c_llings@hotmail.com AIM: WyteLi0n ICQ: 123291844 | |---------------------------------------------------------------| | Y!: j_c_llings Jabber: jcllings@njs.netlab.cz | -----------------------------------------------------------------
Hi Jim -- My OpenLDAP directory when well tuned and absolutely hammered outruns a well tuned MySQL server. YMMV, as always. Different applications and different configurations run differently using different software. But duh. Why bother with LDAP? I authenticate 15,000 users off of an existing LDAP direcory for a number of different services, including UNIX logins, mail processing, and Windows logins. The UNIX logins and mail processing were in place and using LDAP well before I integrated Samba into my LDAP directory. Why would I not use the LDAP backend when everything else in my network does? Or to turn your question around on you, why would I bother with SQL? -jag On Wed, 2004-07-14 at 09:54, Jim C. wrote:> How does the speed of SQL compare to the speed of LDAP? If the speeds > are comparable, why bother with LDAP, which doesn't handle writes very well? > > > Jim C. > -- > > ----------------------------------------------------------------- > | I can be reached on the following Instant Messenger services: | > |---------------------------------------------------------------| > | MSN: j_c_llings@hotmail.com AIM: WyteLi0n ICQ: 123291844 | > |---------------------------------------------------------------| > | Y!: j_c_llings Jabber: jcllings@njs.netlab.cz | > ------------------------------------------------------------------- Joshua Ginsberg <joshg@brainstorminternet.net> Brainstorm Internet Network Operations
Jim C. wrote:> How does the speed of SQL compare to the speed of LDAP? If the speeds > are comparable, why bother with LDAP, which doesn't handle writes very > well?I can't comment on the speed, but as for the reasons for LDAP, some of us need fully networkable and redundant directory information structure. Also, aside from simply handling posix and sambaSam info, ours also does automount information, as well as a custom built directory security enfocement suite. Our mail server runs aliases off of it, and our intranet authenticates against it using posix groups for permissioning. Does sql do all that? oh yeah, and be distributed. Now here's one for you to try... if you want SQL someplace, how about configuring your ldap (assuming openldap) daemon to use back_sql? I've seen the complaints about berkely-db being shoddy, that should take it out of the equation. -- Paul Gienger Office: 701-281-1884 Applied Engineering Inc. Cell: 701-306-6254 Information Systems Consultant Fax: 701-281-1322 URL: www.ae-solutions.com mailto:pgienger@ae-solutions.com
hi, ldap has a good replication feature , which is easy to setup and needed havin a bdc I dont know if this works with mysql ( maybe with shared databases ) but it wouldnt be an easy thing to do Regards Jim C. schrieb:> How does the speed of SQL compare to the speed of LDAP? If the speeds > are comparable, why bother with LDAP, which doesn't handle writes very > well? > > > Jim C.