Jump to content

getProducts Query is very slow


Recommended Posts



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

  • 1 month later...
  • 4 years later...

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

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...