[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/