News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

[SOLVED] Very slow categories

Started by EvanGR, March 29, 2021, 10:55:32 AM

Previous topic - Next topic

EvanGR

EDIT: Solved! Virtuemart->Configuration->Shopfront->Product Listing   disabled "Show product customfields in browse views"


----------ORIGINAL POST--------------
Hello,

Trying to optimize a VM website pagespeed, and we have stumbled in category views...

Product view: 500ms - 1sec max ???
Category view: 5-10seconds (!)

Things to consider:

1) The category view loads no more than 12 products in a single page.
2) We have disabled all forms of caching to test the performance in a consistent way
3) We do all tests on a stock vmbeez template
4) Yes, products have custom fields (VM and breakdesigns cf4all as well). But we have disabled all CF related modules for our tests.

How do we troubleshoot this?

Thank you

[VM 3.8.9.10473, Joomla 3.9.24]

pinochico

#1
where is slow-log DB and Joomla DB debug?
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds for FB, GMC,.. from products, categories, orders, users, articles, acymailing subscribers and database table
Virtuemart Email Manager - customs email templates
Import products for Virtuemart - from CSV and XML
Rich Snippets - Google Structured Data
VirtueMart Products Extended - Slider with products, show Others bought, Products by CF ID and others filtering products

EvanGR

Quote from: pinochico on March 29, 2021, 12:03:55 PM
where is slow-log DB and Joomla DB debug?

I am embarrassed to say I do not know what these are. Could you give me any links to find out more? Thanks!

pinochico

QuoteJoomla DB debug?

Setup in joomla setup - Global configuration / System / Debug system
Show product detail
Look in DB query in bottom

Quoteslow-log DB

ask your hosting
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds for FB, GMC,.. from products, categories, orders, users, articles, acymailing subscribers and database table
Virtuemart Email Manager - customs email templates
Import products for Virtuemart - from CSV and XML
Rich Snippets - Google Structured Data
VirtueMart Products Extended - Slider with products, show Others bought, Products by CF ID and others filtering products