Performance Issues When Running Subtree Queries on Attributes Other Than RDN (242147)



The information in this article applies to:

  • Microsoft Site Server 3.0

This article was previously published under Q242147
NOTE: The information in this article was originally included in the Site Server 3.0 Service Pack 2 Readme_sp2.htm file.

SUMMARY

When you run subtree queries on attributes other than the Relative Distinguished Name (RDN), some Personalization and Membership (P&M) performance issues may occur.

MORE INFORMATION

For most LDAP commands, upgrading the Directory Store to Microsoft SQL Server 7.0 provides equal or enhanced performance over SQL Server 6.5. There are a few conditions, however, that lead to a degradation of performance. These conditions occur when you perform LDAP subtree searches in a SQL Server 7.0 environment. The problem lies in the filters that contain attributes other than the RDN. For example, a partial subtree search originating from the "ou=members" container, where the query filter specifies the LDAP server, should return all objects with "givenName=bob*".

Modification Type:MajorLast Reviewed:8/4/2000
Keywords:kbhowto KB242147