Author Topic: Speed up category pages?  (Read 605 times)

EvanGR

  • Jr. Member
  • **
  • Posts: 300
Speed up category pages?
« on: October 04, 2019, 10:33:20 am »
VM 3.6.2/ 40k products with multiple custom fields used.

Category pages are slower than we'd like (6+ seconds), and we are trying to optimize them.
Perhaps we can do without the custom fields for category product results.
Is there a way to remove custom field SQL queries for category results? If so, which are the query files we can experiment with?

Thanks

Studio 42

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 4184
  • Joomla & Virtuemart developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3
Re: Speed up category pages?
« Reply #1 on: October 04, 2019, 11:25:21 am »
Have you checked the config? You have an option to not render customfields in category view

EvanGR

  • Jr. Member
  • **
  • Posts: 300
Re: Speed up category pages?
« Reply #2 on: October 15, 2019, 08:47:46 am »
Thanks. I cannot seem to find that option... Where do I need to look?

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9394
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: Speed up category pages?
« Reply #3 on: October 15, 2019, 09:23:55 am »
vm config-> config->shop front-> Show product customfields in browse views
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

EvanGR

  • Jr. Member
  • **
  • Posts: 300
Re: Speed up category pages?
« Reply #4 on: October 16, 2019, 08:26:10 am »
Thanks, does this also remove the processing (db queries) for the custom fields for the category pages?

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10399
  • VirtueMart Version: 3+
Re: Speed up category pages?
« Reply #5 on: October 16, 2019, 15:23:12 pm »
Thanks, does this also remove the processing (db queries) for the custom fields for the category pages?


YES, the checkbox just makes them "available" , in other words the queries.
J3.9+ VM 3.4.2
Slowest Page Speed Score (88) (Category)
Fastest Page Speed Score (94-96) (productdetails)