Author Topic: [SOLVED] Very slow categories  (Read 378 times)

EvanGR

  • Jr. Member
  • **
  • Posts: 429
[SOLVED] Very slow categories
« 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]

pinochico

  • 3rd party VirtueMart Developer
  • Full Member
  • *
  • Posts: 1126
    • MiniJoomla
  • Skype Name: support-easysoftware
  • VirtueMart Version: 3
Re: Very slow categories
« Reply #1 on: March 29, 2021, 12:03:55 pm »
where is slow-log DB and Joomla DB debug?
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds from products, orders and database table
Virtuemart Email Manager - customs email templates

EvanGR

  • Jr. Member
  • **
  • Posts: 429
Re: Very slow categories
« Reply #2 on: March 29, 2021, 14:26:57 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

  • 3rd party VirtueMart Developer
  • Full Member
  • *
  • Posts: 1126
    • MiniJoomla
  • Skype Name: support-easysoftware
  • VirtueMart Version: 3
Re: [SOLVED] Very slow categories
« Reply #3 on: March 29, 2021, 14:32:37 pm »
Quote
Joomla DB debug?

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

Quote
slow-log DB

ask your hosting
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds from products, orders and database table
Virtuemart Email Manager - customs email templates