sooly Posted May 30, 2019 Share Posted May 30, 2019 (edited) Hello everyone, Im having eshop with 400 000 products and my search queries takes about 9 seconds to process. I have indexed everything. Our MYSQL runs on SSD. Search priorities are set to : Product name : 10 Product refference : 5 Others: 0 webpage: https://powerparts.cz Is there any way to speed up search? Or recode search.php ? Thanks. Edited May 30, 2019 by sooly (see edit history) Link to comment Share on other sites More sharing options...
Janett Posted May 30, 2019 Share Posted May 30, 2019 Search with MySQL is slow. You should use more professional tool for search in your case. Like elasticsearch for example. You need to find a better search engine Link to comment Share on other sites More sharing options...
musicmaster Posted June 2, 2019 Share Posted June 2, 2019 There are several modules to connect with Elasticsearch. See for example https://github.com/Invertus/PrestaShop-ElasticSearch and https://addons.prestashop.com/en/search-filters/19527-elasticsearchconnector.html Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now