Full_Name: Raphael Ouazana
Version: 2.4.38
OS: Linux
URL:
ftp://ftp.openldap.org/incoming/
Submission from: (NULL) (88.173.78.196)
Hi,
I have a case where using modifyTimestamp index is far slower than with no
index.
First with indexing:
###Caching
$ time ldapsearch -b <people> -D <manager> -W
# search result
search: 2
result: 0 Success
# numResponses: 293886
# numEntries: 293885
real 0m12.153s
user 0m7.805s
sys 0m1.888s
### Request
$ time ldapsearch -b <people> -D <manager> -W
'(&(modifyTimestamp>=20131023163804Z)(modifyTimestamp<=20131123163804Z))'
# search result
search: 2
result: 0 Success
# numResponses: 24277
# numEntries: 24276
real 0m23.441s
user 0m0.554s
sys 0m0.073s
Now without modifyTimestamp index:
###Caching
$ time ldapsearch -b <people> -D <manager> -W
# search result
search: 2
result: 0 Success
# numResponses: 293886
# numEntries: 293885
real 0m11.627s
user 0m7.354s
sys 0m1.772s
### Request
$ time ldapsearch -b <people> -D <manager> -W
'(&(modifyTimestamp>=20131023163804Z)(modifyTimestamp<=20131123163804Z))'
# search result
search: 2
result: 0 Success
# numResponses: 24277
# numEntries: 24276
real 0m0.701s
user 0m0.569s
sys 0m0.070s
As you can see, without indexing the request takes less than 1s, while with
index it takes more than 20s. I think it is not the expected result.
Regards,
Raphaël Ouazana.