[Date Prev][Date Next]
Re: Appropriate index for <= >= filter on generalizedTime
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
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/