DogMall Posted January 23, 2018 Share Posted January 23, 2018 Hello, Unfortunately, the search did not yield a result. I have a shop with about 5000 articles. Each time I call the function getProducts (classes/categories.php), for example on category pages, first all 5000 articles in the query are looped then limited to 21 (which is the number of articles that should appear on a page). The original query needed about 30 seconds on my server. I then removed the ORDER BY command, whereupon the query took only 3 seconds. Is there a way to make the query even faster, and also to keep the ORDER BY command? I would be very happy about every help. Link to comment Share on other sites More sharing options...
DogMall Posted February 27, 2018 Author Share Posted February 27, 2018 Hi, nobody has any idea how to improve the speed? How long are your query times on the category sites? I can't imagine that the sites are loading so long on every Prestashop. Link to comment Share on other sites More sharing options...
Ali Samie Posted January 23, 2023 Share Posted January 23, 2023 I have the same issue but found almost nothing for this. We have about 120k products and something like 300 categories 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