Re: Appropriate index for <= >= filter on generalizedTime

[Howard Chu <hyc@symas.com>]

Roman Rybalko wrote:
> 25.09.2012 01:31, Howard Chu ÐÐÑÐÑ:
> > Aside from the equality index, there's not much else to be done. I'd
> > suggest you pull the code in RE24 and see how back-mdb performs with
> > your data.
> Pulled 2a68553ec103eec28237c2608b3fea149a492b76
> Tried mdb - works completely the same way.

Looks to me like it's 4-5x faster.....

> (&(logTime>=20120816200001+0400)(logTime<=20120816200501+0400)) - 12sec
> (|(logTime=20120816200001+0400)(logTime=20120816200501+0400)) - 0.01sec
> ~ 100000 objects in db
>
> Should I rely only on (|(=)(=)(=)(=)...) filters ?

If that suits you, sure. Personally I would submit an enhancement request to 
the ITS about getting this indexing code restructured. Ideally with a patch 
attached, fixing it as desired.

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