Performance issues in Sitecore Client when complex security roles structure is used


Description

The RolesInRoles provider executes a separate SQL query to resolve subroles of each user's role. This can lead to slow response time in various parts of the Sitecore interface when a complex roles structure is used.

Solution

The following patch adds a new RolesInRoles provider that uses a single query to get the results:

  1. Place the attached Sitecore.Support.455141.config file into the /App_Config/Include folder.
  2. Place the attached Sitecore.Support.455141.dll file into the /bin folder.