Service manual

Costs: How Updates Affect Indexes
Chapter 7 Tuning Indexing 133
In adding this entry, Directory Server must modify indexes for cn, sn, mail,
telephoneNumber,anddescription. Table 7-2 illustrates the expected number of
entries.
Notice that the number of substring index updates for the
description string is
larger (47) than the number of updates (44) for all other attributes combined. Also,
further modifications to the
description string may again imply a maximum
number of updates or more depending on the new string. In most cases, avoid
substring indexing of this volume by not applying substring indexing to long
strings such as
description values.
Code Example 7-1 Sample User Entry
dn: uid=yyorgens,ou=People,dc=example,dc=com
objectclass: top
objectclass: person
objectclass: organizationalPerson
objectclass: inetOrgPerson
uid: yyorgens
givenName: Yolanda
sn: Yorgenson
cn: Yolanda Yorgenson
mail: [e-mail]
telephoneNumber: 1-650-960-1300
description: Business Development Manager, Platinum Partners
Table 7-2 Index Updates for Sample User Entry
Attribute Approximate Equality Substring
1
1. Substring indexing on strings as long as the description string here is not recommended for most deployments.
Total Index Updates
uid 11
cn 111719
sn 11911
mail 11
telephoneNumber 111 12
description 47 47