[Date Prev][Date Next]
RE: Speeding up queries ... or am I doing it the wrong way?
> -----Original Message-----
> From: owner-openldap-software@OpenLDAP.org
> [mailto:owner-openldap-software@OpenLDAP.org]On Behalf Of Andrew Findlay
> On Fri, Mar 21, 2003 at 04:36:06PM -0500, John Ziniti wrote:
> > I've got indices:
> > index objectClass pres,eq
> > index cn,sn,uid,gidNumber,uidNumber,memberUid eq
> > index uniqueMember pres,eq
> Why not add 'pres' to the second line? It costs almost nothing and may
> well help.
Nothing comes for free - it's better not to set any indices that you don't
actually use in your searches. It's also not much benefit to set a presence
index on attributes that normally occur on the majority of your entries. The
information model requires all entries to have an objectclass, so presence
index on objectclass is useless.
-- Howard Chu
Chief Architect, Symas Corp. Director, Highland Sun
Symas: Premier OpenSource Development and Support