[SOLVED] Very slow categories

[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]

where is slow-log DB and Joomla DB debug?

[EvanGR]

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]

Joomla DB debug?

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

slow-log DB

ask your hosting