Prestashop Search Functionality Optimising
Pretashop 1.6.1.4
[login to view URL]
MSG from Hosting site.
I have found that during these periods where the website has been slow/unresponsive, there are a number of long running MySQL queries using up the CPU resources on the server.
There were 6 copies of the below query running for over 10 minutes, and it appears to be related to product searches.
"SELECT si.id_product FROM ps_search_word sw LEFT JOIN ps_search_index si ON sw.id_word = si.id_word WHERE sw.id_lang = 1 AND sw.id_shop = 1 AND [login to view URL] LIKE '%%';"
We would recommend a Presta shop developer check your sites product search functionality, for optimising the product searches.
If you have any further questions, please let us know.