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

performance - how to index for most performance

To: openldap-software@OpenLDAP.org
Subject: performance - how to index for most performance
From: christian gattermair <christian.gattermair@mci.edu>
Date: Mon, 10 May 2004 16:35:47 +0200
Content-disposition: inline
Organization: MCI
User-agent: KMail/1.6.2

hi!

what do i have to index for best performance: each field or everything in a 
line.

at the mom it looks:

index   default pres,eq
index   objectClass,uid,uidnumber,gidnumber,cn
index   mail,mailalternateaddress,mailforwardingaddress eq


my object's are:

top, person organizationalPeron, qmailUser, posixAccount, PureFTPdUser, 
hordePerson and cms


my fields are:

FTPStatus, forumStatus, displayName, uid, FTPQuotaMBytes, loginShell, 
userPassword, mailMessageStore, uidNumber, accountStatus, 
mailAlternateAddress, gidNumber, sn, homeDirectory, mail, 
mailForwardingAddress, givenName, cn, alohaStatus, ximsStatus

thx4tips :-)

Follow-Ups:
- Re: performance - how to index for most performance
  - From: Frank Swasey <Frank.Swasey@uvm.edu>
- Re: performance - how to index for most performance
  - From: Hallvard B Furuseth <h.b.furuseth@usit.uio.no>

Prev by Date: Re: GSSAPI fails?
Next by Date: regex in search filter?
Index(es):
- Chronological
- Thread