[Date Prev][Date Next]
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:
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/