sifo1515 Posted February 4, 2018 Share Posted February 4, 2018 Hi Everyone How to create search index faster ? Best Regards. Link to comment Share on other sites More sharing options...
musicmaster Posted February 4, 2018 Share Posted February 4, 2018 What is the problem? Normally Prestashop only indexes products that are being changed. The only thing that I can think of that could work is limiting the number of fields that are being indexed. If you don't use some fields or if - for example - your description always contains the same text as the short description you could set the weight of those fields to zero. Of course there are also some search modules for sale. Link to comment Share on other sites More sharing options...
sifo1515 Posted February 4, 2018 Author Share Posted February 4, 2018 Hi Musicmaster thanks for your reply my problem " after delete some product , search doesnt work correct and cant find most of product" so i need to re create search indexs. best regarrd. Link to comment Share on other sites More sharing options...
musicmaster Posted February 4, 2018 Share Posted February 4, 2018 The search index works by storing all your keywords in two database tables. Deleting a product shouldn't be more than deleting a few rows from those tables. Not something time consuming. It sounds to me like in your case the mysql indexation of those tables goes somewhere wrong. So I would rather think of mysqlrepair or a similar tool. Link to comment Share on other sites More sharing options...
Pierre_d Posted February 4, 2018 Share Posted February 4, 2018 If you have a large catalog, as we had (14000 products), rebuilding the indexes can take some time. Before we shortened our catalog to 2500 products, I used to build the search indexes in my dev environment then import them back to production. Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted February 4, 2018 Share Posted February 4, 2018 we are moving clients off ps search to elastic search....1.7 search has some signficant issues we got tired of dealing with and are replacing. see addon's for appropriate module..... Link to comment Share on other sites More sharing options...
sifo1515 Posted February 4, 2018 Author Share Posted February 4, 2018 Thanks All Of Your Reply. Now i have 35000 product and it is getting higher. Actually i have "search" problem ,it is more important than indexing, for example i search "john doe " but all result about doe ,is not john. if i search only "john", results about john. İ want to show only matched correct result. if there is nothing about "john doe" there would show no result found. Best Regards. Link to comment Share on other sites More sharing options...
musicmaster Posted February 5, 2018 Share Posted February 5, 2018 Sometimes it helps to use the search.php file from an older Prestashop version. But we don't even know your Prestashop version.... 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