VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: EvanGR on March 29, 2021, 10:55:32 AM

Title: [SOLVED] Very slow categories
Post by: EvanGR on March 29, 2021, 10:55:32 AM
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]
Title: Re: Very slow categories
Post by: pinochico on March 29, 2021, 12:03:55 PM
where is slow-log DB and Joomla DB debug?
Title: Re: Very slow categories
Post by: EvanGR on March 29, 2021, 14:26:57 PM
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!
Title: Re: [SOLVED] Very slow categories
Post by: pinochico on March 29, 2021, 14:32:37 PM
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