DogMall Posted January 23, 2018 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. Share this post Link to post Share on other sites More sharing options...
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 account
Already have an account? Sign in here.Sign In Now