News:

Support the VirtueMart project and become a member

Main Menu

Speed up category pages?

Started by EvanGR, October 04, 2019, 10:33:20 AM

Previous topic - Next topic

EvanGR

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

Have you checked the config? You have an option to not render customfields in category view

EvanGR

Thanks. I cannot seem to find that option... Where do I need to look?

GJC Web Design

vm config-> config->shop front-> Show product customfields in browse views
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 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
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

EvanGR

Thanks, does this also remove the processing (db queries) for the custom fields for the category pages?

PRO

Quote from: EvanGR 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?


YES, the checkbox just makes them "available" , in other words the queries.