Microsoft KB Archive/242147

= Performance Issues When Running Subtree Queries on Attributes Other Than RDN =

Article ID: 242147

Article Last Modified on 8/4/2000

-

APPLIES TO


 * Microsoft Site Server 3.0 Standard Edition

-



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*".

Additional query words: ss3 sp2 kbreadme readme speed slowness sluggish akz

Keywords: kbhowto KB242147

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.