Description

Opening a page in the Experience Editor might take a long time due to a large number of records in the sitecore_suggested_test_index.

Solution

To resolve the issue, consider one of the following options:

• Download and install the patch compatible with the affected product version found on this page:
  https://github.com/SitecoreSupport/Sitecore.Support.185487/releases
  
  
• Disable the suggested test count call while loading the Experience Editor as follows:
  
  
  1. 1. Open the \sitecore\shell\client\Sitecore\ContentTesting\ShowSuggestedTestCommand.js file and find the following code:
        
        
        • For Sitecore XP 8.2.0 - 8.2.7:

          canExecute: function (context) {
              var testCount = context.app.canExecute("Optimization.SuggestedTests.Count", context.currentContext);
              var outputEl = $("a[data-sc-id='Suggested-Tests'] span");
              var counterSpan = "<span> (" + testCount + ")</span>";

        • For Sitecore XP 9.0.0 and later:

          canExecute: function (context) {
                  var self = this;
                  self.setLoadingAnimation(true);
                  context.app.canExecute("Optimization.SuggestedTests.Count", context.currentContext, function (testCount) {
                    self.setLoadingAnimation(false);
                    self.fillupSuggestedTestsCount(testCount);
                  });

     2. Replace the value of testCount and counterSpan variables as follows:
        
        
        • For Sitecore XP 8.2.0 - 8.2.7:

          canExecute: function (context) { var testCount = 0;
          var outputEl = $("a[data-sc-id='Suggested-Tests'] span");
          var counterSpan = ""; 

        • For Sitecore XP 9.0.0 and later:

           canExecute: function (context) {
           var self = this;
           // self.setLoadingAnimation(true);
           // context.app.canExecute("Optimization.SuggestedTests.Count", context.currentContext, function (testCount) {
           //   self.setLoadingAnimation(false);
           //   self.fillupSuggestedTestsCount(testCount);
           // });
           self.fillupSuggestedTestsCount(0);

     3. Clear the browser cache.
        
        
• When Content Testing is not used, change the ContentTesting.AutomaticContentTesting.Enabled setting value to "false" in the App_Config\Include\ContentTesting\Sitecore.ContentTesting.config file:

  <setting name="ContentTesting.AutomaticContentTesting.Enabled" value="false" />