Performance Issues When Running Subtree Queries on Attributes Other Than RDN

ID: Q242147

The information in this article applies to:

Microsoft Site Server version 3.0

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

Keywords : SS3SP3Fix
Version : winnt:3.0
Platform : winnt
Issue type : kbhowto