Description

Executing search queries might result in the increased resource consumption and increased response time due to redundant requests to Solr. Messages similar to the following can be found in the logs:

INFO Solr Query - ?q=__solr_norm_field_name_s:(_lastestversion)&rows=1&fq=_template:(455a3e98a6274b408035e683a0331ac7)&fq=_indexname:(sitecore_web_index)&wt=xml
INFO Solr Query - ?q=__solr_norm_field_name_s:(_url)&rows=1&fq=_template:(455a3e98a6274b408035e683a0331ac7)&fq=_indexname:(sitecore_web_index)&wt=xml

In Sitecore XP 9.0 and earlier versions, the log entries are similar to:

INFO  Solr Query - ?q=_name:(_lastestversion)&rows=0&fq=_templatename:("Template field")&fq=_indexname:(sitecore_web_index)&wt=xml
INFO  Solr Query - ?q=_name:(_lastestversion)&rows=1000000&fq=_templatename:("Template field")&fq=_indexname:(sitecore_web_index)&wt=xml
INFO  Solr Query - ?q=_name:(_url)&rows=0&fq=_templatename:("Template field")&fq=_indexname:(sitecore_web_index)&wt=xml
INFO  Solr Query - ?q=_name:(_url)&rows=1000000&fq=_templatename:("Template field")&fq=_indexname:(sitecore_web_index)&wt=xml

Solution

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

• Upgrade to Sitecore XP 10.3.
• For versions prior to Sitecore XP 10.3, complete the steps below:
  1. Download the patch file found on this page: https://github.com/SitecoreSupport/Sitecore.Support.314849/blob/v9.0.2/src/Sitecore.Support.314849/App_Config/Include/zzz/Sitecore.Support.314849.config
  2. Put this file into the \App_Config\Include\zzz folder of the website. In the case of a scaled setup, make sure the change is applied both to instances with the ContentManagement role and with the ContentDelivery role.
  The patch file removes the "_url" and "_lastestversion" virtual fields. These fields are not used by Sitecore.