Magento 2.3, a leading e-commerce platform, encounters an issue causing a high CPU load on its database. The culprit is the 'DISTINCT' operator in the search_query table, which, by eliminating duplicate entries, causes delays when processing large volumes of search terms and strains the system. A second complication is the 'num_results > 0' condition, which also extends the execution time by checking for search results over zero. To resolve these issues, two potential solutions come forth. One is to insert search terms in batches asynchronously, which lessens the database's workload. Also, removing the 'DISTINCT' operator, an unnecessary element in the search_query table, could enhance Magento 2.3's performance significantly. Pursuing these solutions may increase the e-commerce platform's efficiency and robustness.
Full article here: https://lawsuithelpdesk.com/unmasking-magento-2-3-the-hidden-culprit-behind-your-surging-database-cpu-load/