I'm trying to use >= <= filter on eq-indexed generalizedTime attribute. Seems eq-index does not work for <= filter.
olcAttributeTypes: ( 2.999.718.104.22.168.5 NAME 'logTime' DESC 'Time' EQUALITY generalizedTimeMatch ORDERING generalizedTimeOrderingMatch SYNTAX 22.214.171.124.4.1.14126.96.36.199.24 )
olcDbIndex: logTime eq
(&(logTime>=201209201440+0400)(logTime<=201209201450+0400)) - 57sec
(|(logTime=20120920144001+0400)(logTime=20120920144008+0400)) - 0.03sec
~ 1000000 records in db, target = 100000000 records
What should I do to make >= filters work efficiently?
I may consider using another data type that work with <=/=> filters for sure. Strings? Integers? Anything that can mimic TIME semantics. Any advice?
14.04.2012 19:44,Â Michael StrÃder ÐÐÑÐÑ:
The same question from me. Is it possible to select indexes using some sort of filter syntax?can I influence the order of index usage by order in the filter or slapd index configuration?
-- WBR, Roman Rybalko