RE: Speeding up queries ... or am I doing it the wrong way?

["Howard Chu" <hyc@highlandsun.com>]

> -----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
  http://www.symas.com               http://highlandsun.com/hyc
  Symas: Premier OpenSource Development and Support