Multi-List with Search Field Performance
We are having a Performance Issue with Sitecore Content Editor where we will select an item and it take 5 to 6 seconds for the right side of Content Editor to appear with the item fields and information. We've gone through a number of settings (disabled cache limits, not render collapsed sections, not display standard fields) and finally taken dotTrace dumps of the action. What we've come to find is that the items displaying the problem have a mutlilist with search field and the calls to Coveo are taking 4+ seconds. The primary case we're working on has a start item specified and filters by 3 different template IDs. There are 2500 items under the start item.
Can anyone suggest any thougths about how we can look into speeding this up?
I appreciate any suggestions/help.
Thank you Ryan
Thank you for the queries. They are simple queries with only exact match field expressions. CES is able to find the search result set very quickly as we can see.
Those queries are probably sent from the Sitecore LINQ module. Can you give me your default number of results setting please? It is the
<DefaultNumberOfResults> node of the
Coveo.SearchProvider.config file. By default, this setting is set to
10 so only the first 10 search results are returned. If you have increased this number, CES would need to send all the fields of all the results to Sitecore. This can be a long operation depending on the number of fields in your field sets and on your search results.
One thing that can be done is to optimize the LINQ queries (see Optimizing LINQ Query Performance).