Performance issue with the My items functionality

  • Description

    You may experience slowness when loading the My items dialog in the Content Editor or Experience Editor. This may generally effect the load time of the Experience Editor, because it renders the My Items button and retrieves locked items in advance in order to show you the locked items count.

    The issue may happen on solutions that have a large master database. It is caused by the incorrectly constructed search expression used to find the locked items. This causes the search expression to fail and fall back to the Sitecore Fast Query, which iterates through the entire master database and drastically increases the load time for all the locked items.

    Note: If you use Solr search provider, the following error may appear in the Search log files:

    ERROR Solr Error : ["undefined field search"] - Query attempted:

    [(_name:(search://*[@__lock='%"sitecore\admin"%']*) OR _content:(*search://*[@__lock='%"sitecore\admin"%']*))]

  • Solution 1 - Applicable for Sitecore 7.2 — 7.5

    Apply the following patch:

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

    Note: This patch can be applied only if you maintain the Quick search index. Please make sure that the index update interval is not set to "00:00:00":

    <-- INDEX UPDATE INTERVAL
    Gets the interval between the IndexingManager checking its queue for pending actions.
    Default value: "00:05:00" (5 minutes)
    -->
    <setting name="Indexing.UpdateInterval" value="00:05:00 />"
  • Solution 2 - Applicable For Sitecore 7.2 — 8.1 Update-2

    Apply the following patch:

    1. Place the Sitecore.Support.419438.dll assembly into the /bin folder.

      Sitecore CMS 7.2 — XP 8.0:
      Sitecore XP 8.1:
    2. Place the Sitecore.Support.419438.config file into the /App_Config/Include folder.

      Sitecore CMS 7.2 — XP 8.0:
      Sitecore XP 8.1:


    3. If you are using Sitecore XP 8.0 or later place the Sitecore.Support.131964.dll assembly into the /bin folder and the Sitecore.Support.131964.config file into the /App_Config/Include folder.


    4. Rebuild the sitecore_master_index.

  • Solution 3 - Applicable for 8.1 Update-3, Sitecore 8.2 and later

Applies to:

CMS 7.2+

February 26, 2016
August 29, 2017

Reference number:

419438, 95319, 131964

Keywords: 

  • Performance