Marc wrote:
I am trying to tune my search performance - I ran two searches for the same results, one from the top branch of our tree and filtered by objectclass and attribute. The other from directly from the branch that housed all the results and just filtered by attribute.
The first search took 4 minutes to return 11,000 results, while the second search took 2 minutes to return the same results. I'm not concerned with the amount of time to return the search, I am more concerned with the 50% increased efficieny. Any help would be greatly appreciated.
Assume using Netscape Directory server. Your return set is over default "all ids threshold" 4000, the index is no longer used for searching. It returns results by sequentially checking entries of specified suffix. It seems it searches all the suffixes for your first experiment.
While processing the search operation, a list of candidates is constructed. If the list length is over threshold then turn to linear search, instead of fast index searching. With the assumption that so many entries match that it would be necessary to retrieve a sufficiently large portion of the directory server database anyway.
You can set a high value for nsslapd-allidsthreshold at database suffix entry to raise the "all ids threshold" to improve performance. However, you need to reindex the suffix after value changed and it takes longer for write/modify operations.
Hope that helps.
-ey
_______________________________________________ mozilla-directory mailing list [EMAIL PROTECTED] http://mail.mozilla.org/listinfo/mozilla-directory
