fbpx
Solving the Magento 2.3 Upgrade Conundrum: Unmasking the Search Term Cache Culprit Hampering Database Performance

Solving the Magento 2.3 Upgrade Conundrum: Unmasking the Search Term Cache Culprit Hampering Database Performance

The upgrade to Magento 2.3 has led to a performance issue involving the search term cache, causing increased CPU load on databases. This occurs due to the condition 'num_results > 0' in search-related operations, leading to lengthy database queries, especially with large search_query tables. This issue could potentially affect e-commerce operations. Proposed solutions include overriding the execute function in Magento_CatalogSearch/Controller/Result/Index, indexing the search_query table, and using ElasticSearch for search operations. Removing the DISTINCT operator from queries within Magento\Search\Model\ResourceModel\Query\Collection may also improve performance. However, these solutions need to be thoroughly tested for potential impact on other Magento platform aspects.

Full article here: https://medium.com/@lawsuithelpdesk/solving-the-magento-2-3-7612b4f8df3f

YouTube
LinkedIn
LinkedIn
Share