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

Re: reqStart<= slow

Michael StrÃder wrote:

I'm trying to retrieve change events from accesslog DB (all with today's
RE24). I tried searching with this filter:

(&(reqDN=cn=Test-Mail-Gruppe 1,dc=example,dc=com)(reqStart<=20120413180000Z))

This turned out to be quite slow though. reqDN is indexed and there are only
two possible entries. Using a filter reqStart>= even when negated with (!())
is pretty fast.

Is reqStart indexed?

I really wonder why that is.

Obviously, for any database that has been around for even a short while, there will be far fewer records with a date newer than [today's date] as opposed to older than then.

  -- Howard Chu
  CTO, Symas Corp.           http://www.symas.com
  Director, Highland Sun     http://highlandsun.com/hyc/
  Chief Architect, OpenLDAP  http://www.openldap.org/project/