Michael Ströder wrote:
HI!
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/
