That shouldn't matter. I don't have a mailAlternateAddress index, even though it's in slapd.conf, and I still do POP3 lookups quickly (fast enough that I can not measure a noticable delay). My OpenLDAP has about 25k entries right now.
What kind of CPU usage is OpenLDAP taking, and is it getting any large queries from other sources that are not for indexed attributes? If it's single threaded (can't see why it would be in a SMP environment, but just in case), it'll only answer one query at a time, which hurts performance rather dramatically. Dave ----- Original Message ----- From: "K. F. Yim" <[EMAIL PROTECTED]> To: "Salvador Ramirez" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, October 24, 2001 5:42 AM Subject: Re: SUMMARY: Qmail - OpenLDAP performance? > Did you try to add one entry with mailAlternateAddress into LDAP. Index file > will not be created in OpenLDAP until one entry with index created. > > KF > ----- Original Message ----- > From: "Salvador Ramirez" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, October 23, 2001 9:33 PM > Subject: SUMMARY: Qmail - OpenLDAP performance? > > > > Hi, > > > > Thanks to all who answered. > > > > Unfortunetly I've received answer with solutions that I've > > already tried: > > > > - Increasing the cachesize and dbcachesize parameters > > - Including the indexes: mail and mailAlternateAddress and > > running slapindex after the changes keeping down slapd > > > > However I still got a poor performance when my OpenLDAP > > server have more than 15000 entries.. perhaps I should > > redirect this question to the OpenLDAP mailing list.. > > > > Thanks and best regards, > > > > ---sram > > > > > > > ----- Original Message ----- > > > From: "Salvador Ramirez" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Monday, October 22, 2001 11:38 PM > > > Subject: Qmail - OpenLDAP performance? > > > > > > > > > > Hi, > > > > > > > > I've installed OpenLDAP 2.0.11 with qmail with LDAP support. > > > > My computer is an IBM Netfinity 7100 with 2 PIII Xeon cpus at > > > > 700MHz, and 512 of main memory. The OS is RedHat 7.1. > > > > > > > > I ported about 17000 unix nis accounts to openldap but the > > > > LDAP authentication with qmail is very slow, 3 or 4 seconds and > > > > when there are lots of email arriving these operations takes > > > > the 100% of the two cpus of my server. I thought that the problem > > > > could be the indexes of the openldap configuration, I then modify > > > > slapd.conf for the indexes in this way: > > > > > > > > index cn,uid pres,eq,sub > > > > index uidNumber eq > > > > index objectClass eq > > > > > > > > As I said I was using NIS, and AFAIK this uses similar DB > > > > libraries (dbm or berkeley DB) of that of OpenLDAP to index > > > > the search elements so I can't figure out why I'm having this > > > > problem. > > > > Does anyone else have had a problem like this with this amount > > > > of users? I have to add also that with less than 1000 users > > > > all works fine! > > > > Any help will be very appreciated. > > > > Thanks in advance, > > > > > > > > ---sram > > > > "Don't listen to what I say; listen to what I mean!" --Feynman > > > > Salvador Ramirez Flandes PROFC, Universidad de Concepcion, > CHILE > > > > http://www.profc.udec.cl/~sram > mailto:[EMAIL PROTECTED] > > > > > > > > > _________________________________________________________ > > > Do You Yahoo!? > > > Get your free @yahoo.com address at http://mail.yahoo.com > > > > > > > > > > > > >
