Hello,
I have in my own schema an attribute defined:
attributetype (1.3.6.1.4.... NAME ('InsertTime') EQUALITY generalizedTimeMatch ORDERING generalizedTimeOrderingMatch SYNTAX 1.3.6.1.4.1.1466.115.121.1.24 )
Now I can use this and search, but it takes very long.
So I want index it for searching:
* greater (">=") * less ("<=")
Is it possible and how can I do this?
I have only seen "eq" and "pres".
Thanks in advance Meike
On Fri, 4 May 2012 14:13:38 +0200, Meike Stone wrote:
attributetype (1.3.6.1.4.... NAME ('InsertTime') EQUALITY generalizedTimeMatch ORDERING generalizedTimeOrderingMatch SYNTAX 1.3.6.1.4.1.1466.115.121.1.24 )
Now I can use this and search, but it takes very long.
So I want index it for searching:
- greater (">=")
- less ("<=")
Use an eq index. This doubles as an ordering index for some non-string syntaxes, including integer, generalizedTime, and (I think) CSN.
Hallvard
Hallvard Breien Furuseth wrote:
On Fri, 4 May 2012 14:13:38 +0200, Meike Stone wrote:
attributetype (1.3.6.1.4.... NAME ('InsertTime') EQUALITY generalizedTimeMatch ORDERING generalizedTimeOrderingMatch SYNTAX 1.3.6.1.4.1.1466.115.121.1.24 )
Now I can use this and search, but it takes very long.
So I want index it for searching:
- greater (">=")
- less ("<=")
Use an eq index. This doubles as an ordering index for some non-string syntaxes, including integer, generalizedTime, and (I think) CSN.
I brought up this discussion before: http://www.openldap.org/lists/openldap-technical/201204/msg00116.html
In case the range filter is combined with a another indexed filter the eq-index can even lead to slower searches.
Ciao, Michael.
Thanks for *both* advices, that helped me a lot!
Kind regards
Meike
2012/5/4 Michael Ströder michael@stroeder.com:
Hallvard Breien Furuseth wrote:
On Fri, 4 May 2012 14:13:38 +0200, Meike Stone wrote:
attributetype (1.3.6.1.4.... NAME ('InsertTime') EQUALITY generalizedTimeMatch ORDERING generalizedTimeOrderingMatch SYNTAX 1.3.6.1.4.1.1466.115.121.1.24 )
Now I can use this and search, but it takes very long.
So I want index it for searching:
* greater (">=") * less ("<=")
Use an eq index. This doubles as an ordering index for some non-string syntaxes, including integer, generalizedTime, and (I think) CSN.
I brought up this discussion before: http://www.openldap.org/lists/openldap-technical/201204/msg00116.html
In case the range filter is combined with a another indexed filter the eq-index can even lead to slower searches.
Ciao, Michael.
openldap-technical@openldap.org
-
Hallvard Breien Furuseth -
Meike Stone -
Michael Ströder