ricky11 Posted September 23, 2014 Share Posted September 23, 2014 Setup: Using 1.6.0.9 Uninstalled unneeded modules and analytics, including best sales/top sellers,etc, disabled all non prestashop modules using default them All optimizations turnon, no cdn, disabled minify html. Index page has no product listing only slider and advertising module, top menu, cart block, currencyblock + Facebook social plugin. based on the above their should be a low number of database queries run when no items in cart. I am getting 33 queries being executed on main page without any items in cart. As soon as one items is added in cart, the main page goes from 33 queres to 80-81 queries per page. Is this normal? Is there is a need to run all these queries in teh index page when i am not showing any database objects on the homepage such as new products or best sellers. If anyone wants to have a look, here is our site with database profiling turned on. thanks. I could not find any topic about how to reduce database query calls. Some of the sql statements seemed so unnecessary, for example language query, if we have only one language why do we need to run this query?? Site here : http://goo.gl/NoplWz Link to comment Share on other sites More sharing options...
nutxlago Posted September 23, 2014 Share Posted September 23, 2014 I cannot offer help on this issue, Ricky11. But I find it very interesting and will follow it. Perhaps someone would help to reduce mysql queries on Prestashop. I find them excessive, too. Link to comment Share on other sites More sharing options...
Recommended Posts