ampourto Posted July 17, 2014 Share Posted July 17, 2014 Hi, i have a problem with search in my shop. i use Prestashop 1.5.2 and when someone search for a products the entry processes became 8-10. Is a problem with sql optimization due too many joins ?(search.php file). Any idea? Thank you Link to comment Share on other sites More sharing options...
PSfever.com Posted July 17, 2014 Share Posted July 17, 2014 What do you mean by became 8-10? Could you give us an example? Link to comment Share on other sites More sharing options...
ampourto Posted July 17, 2014 Author Share Posted July 17, 2014 (edited) when someone search for a product(5 letters min) the entry processes increased from 1 to 8. My limit of entry processes is 50 so many customers view the limit message(serve error 508 page), I believe the problem is too many joins in file classes/product.php and classes/search.php. I have 12000 products. What do you think? Edited July 17, 2014 by ampourto (see edit history) 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