News:

Looking for documentation? Take a look on our wiki

Main Menu

Hundreds Customfields, shop slowed down

Started by Adwans, August 26, 2016, 00:47:45 AM

Previous topic - Next topic

Adwans

Hello everybody,
Joomla! 3.4.8
VM 3.0.12
PHP 5.6
http://www.biurodom.hekko24.pl/index.php/vinduer/pvc-vinduer/sidehengslet-vindu/single-window-tilt-turn-white-detail
http://www.biurodom.hekko24.pl/index.php/vinduer/pvc-vinduer/sidehengslet-vindu
I have a webshop with windows, so: due to fact that a single window appears in many sizes - one product has - let say - about 640 sizes. This means 640 custom fields.
From this moment "category view" as well as "product view" slowed down. server response: about 14-15 sec.
Of course: GZIP is on, Joomla cache in conservative mode is on.
Any idea? And why, for the God's sake, category page slowed down too? Does it load products CFs as well in order to display "category view"? (This category HAS 1 product! LINK above)
What should I do - I cant even imagine having more products, for example 150 windows in hundreds sizes!
Should I "dump" pages / change them into static pages/ use any plugin?
I disabled everything in Joomla except VM, backup plugin, some security stuff...K2 blog... in fact I dont need K2, only VM is mandatory.
Regards! Zbyszek

GJC Web Design

taking the cat page it definitely seems server related - 17+ sec to respond to the 1st GET with all caches cleared

a subsequent reload only takes 250Ms so it is cached

but what I assume is a plain Joomla page (turn off sef so u can actually see what your loading) is not impressive anyway
http://www.biurodom.hekko24.pl/index.php/home

4.5 sec

What are the server specs?
GJC Web Design
VirtueMart and Joomla Developers - php developers [url="https://www.gjcwebdesign.com"]https://www.gjcwebdesign.com[/url]
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
[url="https://extensions.joomla.org/profile/profile/details/67210"]https://extensions.joomla.org/profile/profile/details/67210[/url]
Contact for any VirtueMart or Joomla development & customisation

VMTemplates.net

it looks like a server load issue - check server load using WHM
or contact your server/hosting account provider

Thanks,
J.
We develop VirtueMart templates since 2008
[url="https://www.virtuemarttemplates.net/"]https://www.virtuemarttemplates.net/[/url]
Join the VirtueMart Templates Club today and get an access to over 60 VirtueMart templates
[url="https://www.virtuemarttemplates.net/template-club.html"]https://www.virtuemarttemplates.net/template-club.html[/url]
If you need a custom VirtueMart Template design please visit [url="https://www.virtuemarttemplates.net/custom-virtuemart-template-design.html"]https://www.virtuemarttemplates.net/custom-virtuemart-template-design.html[/url]
Visit our new shop [url="https://demo.virtuemarttemplates.net/"]https://demo.virtuemarttemplates.net/[/url]
Join the VirtueMart Templates Club, purchase the template or order one of our services like Hosting, Website Maintenance, Security and Optimization, Template Customization and more

jenkinhill

And after fixing the host consider updating your versions and switching to PHP7 for greater speed.   http://forum.virtuemart.net/index.php?topic=118683.0
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Adwans

@GJC, @jenkhill, @VMTemplates.net,  thank you for all notices / tests and advises. After upgrading Joomla, VM and switching to PHP7 this bus drives faster ... not Mustang, yet, but - the difference is noticeable.
Maybe hosting parameters is the biggest issue. I will test it. 

GJC Web Design

yes-- the suitability of hosts for a Joomla/VM install can vary hugely.. some are just hopeless
GJC Web Design
VirtueMart and Joomla Developers - php developers [url="https://www.gjcwebdesign.com"]https://www.gjcwebdesign.com[/url]
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
[url="https://extensions.joomla.org/profile/profile/details/67210"]https://extensions.joomla.org/profile/profile/details/67210[/url]
Contact for any VirtueMart or Joomla development & customisation

VMTemplates.net

Try VPS or dedicated. Prices are higher than cheap shared hosting accounts but its worth to spend a little more to improve performance (also for further seo works).
We develop VirtueMart templates since 2008
[url="https://www.virtuemarttemplates.net/"]https://www.virtuemarttemplates.net/[/url]
Join the VirtueMart Templates Club today and get an access to over 60 VirtueMart templates
[url="https://www.virtuemarttemplates.net/template-club.html"]https://www.virtuemarttemplates.net/template-club.html[/url]
If you need a custom VirtueMart Template design please visit [url="https://www.virtuemarttemplates.net/custom-virtuemart-template-design.html"]https://www.virtuemarttemplates.net/custom-virtuemart-template-design.html[/url]
Visit our new shop [url="https://demo.virtuemarttemplates.net/"]https://demo.virtuemarttemplates.net/[/url]
Join the VirtueMart Templates Club, purchase the template or order one of our services like Hosting, Website Maintenance, Security and Optimization, Template Customization and more