In my recent conversations about indexing, I was having problems with indexing. I've managed to get it to work locally, but others are having trouble replicating my working instance.
My question to the group isn't related to that, but to the performance I'm seeing when the indexes are working locally for me. What should I expect to see in terms of performance difference with the indexing in place? I've created a script that uses ldapsearch to search for 10 entries 10 times and I'm actually seeing mixed results where sometimes it is actually *slower* with the indexing in place: ldapsearch -H ldap://localhost:10389 -x -D "uid=admin,ou=system" -b "dc=mfoundry,dc=com" -w secret -s sub -a always "(mfname=$name)" "mfname" "mfuid" "objectClass" >> ~/temp/apachedstests/searchresults.txt With indexing disabled: real 0m8.626s user 0m0.387s sys 0m0.406s With indexing enabled, it is inconsistent, but averages no better: real 0m9.161s user 0m0.381s sys 0m0.391s real 0m8.329s user 0m0.382s sys 0m0.391s real 0m8.357s user 0m0.381s sys 0m0.390s Does that mean that the indexes are not being used? Or does it just mean that my use case isn't something helped by the indexes? Thanks for any insights. Craig -- Craig Setera Director, Product Engineering mFoundry p 415.324.5801 [email protected]
