[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
Re: substring index oddity
John Madden wrote:
This is something of a repeat of a previous post:
http://www.openldap.org/lists/openldap-software/200101/msg00542.html
I think I'm seeing the same sort of behavior. Basically, I've got a directory
with 1 million objects on a machine with 4GB RAM, a cachesize of 100000, and a bdb
cache of 2GB. Searches on an indexed attribute (uid, let's say) returns odd
problems off of substring searches with "index uid sub,eq,pres:"
uid=*222* : 29 seconds
uid=*222 : 0.063 seconds
uid=*2*22 : 0.14 seconds
openldap-2.2.18
linux 2.4.25 2xXeon 2.3GHz
2GB RAM
bdb
db-4.2.52+patches
with ~102.000 entries
index uid pres,sub,eq
ldapsearch only dn times:
"uid=*0371*" dn
# numResponses: 125
# numEntries: 124
real 0m0.052s
user 0m0.020s
sys 0m0.010s
"uid=0371*" dn
# numResponses: 103
# numEntries: 102
real 0m0.065s
user 0m0.020s
sys 0m0.010s
... and obviously:
"uid=*03*71*" dn
# numResponses: 338
# numEntries: 337
real 0m0.490s
user 0m0.030s
sys 0m0.010s
--
____________________________________________________
Ignacio Coupeau, Ph.D. icoupeau@unav.es
CTI, Director icoupeau@alumni.unav.es
University of Navarra icoupeau@ieee.org
Pamplona, SPAIN http://www.unav.es/cti/