VirtueMart Forum

VirtueMart 2 + 3 + 4 => Security (https) / Performance / SEO, SEF, URLs => Topic started by: Adwans on August 26, 2016, 00:47:45 AM

Title: Hundreds Customfields, shop slowed down
Post by: Adwans on August 26, 2016, 00:47:45 AM
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
Title: Re: Hundreds Customfields, shop slowed down
Post by: GJC Web Design on August 26, 2016, 12:02:07 PM
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?
Title: Re: Hundreds Customfields, shop slowed down
Post by: VMTemplates.net on August 26, 2016, 18:58:52 PM
it looks like a server load issue - check server load using WHM
or contact your server/hosting account provider

Thanks,
J.
Title: Re: Hundreds Customfields, shop slowed down
Post by: jenkinhill on August 26, 2016, 19:23:14 PM
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
Title: Re: Hundreds Customfields, shop slowed down
Post by: Adwans on August 30, 2016, 01:33:31 AM
@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. 
Title: Re: Hundreds Customfields, shop slowed down
Post by: GJC Web Design on August 30, 2016, 11:57:13 AM
yes-- the suitability of hosts for a Joomla/VM install can vary hugely.. some are just hopeless
Title: Re: Hundreds Customfields, shop slowed down
Post by: VMTemplates.net on August 30, 2016, 19:10:44 PM
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).