Service manual

Tuning Indexing for Performance
136 Sun ONE Directory Server Installation and Tuning Guide • June 2003
Figure 7-5 Reaching the All IDs Threshold for an Index Key
Notice that the threshold affects only one list in the index table. Lists for otherkeys
are not affected.
Symptoms of Inappropriate Index List Size
If clients perform primarily indexed searches and cache sizes are correctly tuned as
described in Chapter6, “Tuning Cache Sizes,” yet you still observe poor search
performance, an inappropriate threshold value may be the cause. When you
observe poor search performance for indexed searches, ensure cache sizes are
appropriately tuned first. Next, examine the
access log to determine whether
Directory Server is reaching the all IDs threshold often.
Entry IDs
allids smith
wilson
yorgenson
blinn
cubbins
cooper
...
...
SN
entryidentryid entryid entryid entryid entryid entryid entryid entryid
entryid entryid entryid entryid entryid entryid
entryid
entryid
entryid entryid entryid entryid entryid entryid entryid entryid
entryid entryid entryid entryid entryid entryid entryid entryid entryid entryid
entryid entryid entryid entryid entryid
Many entries for people with
surname Smith -- more than
nsslapd-allidsthreshold.
Handled by Directory Server
as an unindexed search.