News:

Looking for documentation? Take a look on our wiki

Main Menu

Too much queries in category view

Started by Peter Pillen, May 28, 2014, 18:30:29 PM

Previous topic - Next topic

Peter Pillen

Site is in development and not accessible without password.

Site: http://test.pillini.be/webshop/schoenen/damesschoenen
User login: demo
Password: demo1
Hosting: siteground
Joomla 2.5.9 + VM 2.6.2

In the link provided above a whopping 5600 queries are executed (I enabled VM debug mode as well as the joomla debug mode). Somehow all queries are executed as normal: menu's, modules, first 24 products, media's and manufacturers and then ... a query that looks up all the info for the other 524 products ... resulting in an extra 5000 queries :/ I have no idea where this is coming from. Does anyone have an idea? The queries seem related to the customs and customfields but I don't know what is triggering this.

The template designer says that these are VM queries/not template queries ... but I don't fully agree. Setting the template to beez5 in VM configuration makes the number of queries drop to 350.

GJC Web Design

First thought is if Beez drops it to 350 then there is something in his template over rides doing all this querying...

try with his template and the folder templates/YOUR_TEMPLATE/html/com_virtuemart remamed to something else

if not see if any modules on a cat page a similarily over ridden
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

Peter Pillen

Thx GjC ... but no solution

Well... funny thing is that i disabled all modules (without exception) and even then I get 5000 queries. 100% sure it is the template now. The limit and limitstart is handled by ajax (not my strongest type of programming) and I suspect that being part of the problem. Does anyone recognize the surplus queries?

GJC Web Design

if u check just the component view  test.pillini.be/webshop/schoenen/damesschoenen?tmpl=component

there are still 4500 queries

multiple groups of 542 × SELECT *   which is identical to the nmber of articles in the cat

542 artikelen - this isn't normal - should only query the number on the page

but impossible to find more without complete access



GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

Peter Pillen

#4
Would you take a look? Tell me what access you need and I will make the necessary logins.

Solved ... the queries are made by the Ajax product filter on the right side. It makes a filter for all the products based on brand, price and possible cart attributes. It needs to run through all products in a categorie in order to make filtering possible. It has some tuning options which I need to look into. Thanks for the help!