Jump to content

A lot of queries during profiling


Daniel

Recommended Posts

Hey!

In Prestashop 1.7.3.0 I have over 50,000 products and for each product, each customer has a special price. When profiling mode is activated, eg on the home page, no products are displayed and the profiler shows over 13,000 pages. SQL queries to the database, most of which are queries about the specific price of each of the products. The loading time of the page without profiling and profiling is more or less the same, with the difference that when the profiling is turned on, the busy / loading circle is spinning and as if these 13,000. inquiries were being done.

Has anyone met with something like that? Why are there so many queries? Even on the side of a single product there are just as many of them. Please help.

Edited by Daniel (see edit history)
Link to comment
Share on other sites

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...