Jump to content

Adjust product listing query to reduce loading time for many articles


Recommended Posts

Hello everyone, I've been looking for a solution for several months now. When I call up a category that has a lot of combinations, it takes about 14 seconds for the page to load. The problem is the query. When opening the category, prestashop loads all combinations from the database and this leads to this eternal waiting time. I have a powerful root server, I adjusted the php and sql settings. I've been stuck with this problem for months now and just can't get any further. I suspect that the SQl query is in /classes/products.php. Does anyone have an idea how I could ensure that no more combinations are loaded during product listing?


Thanks and greetings

Share this post

Link to post
Share on other sites

  • 4 months 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...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More