cancel
Showing results for 
Search instead for 
Did you mean: 

Site Performance with a lot of SKUs

Site Performance with a lot of SKUs

my new site has 400+ products and some of the configurable products have a lot of attributes/over 2500 associated simple SKUs.

 

the configurable products with 4000+ associated simple SKUs actually do not display as the request times out...so I have had to disable them from a customer experience point of view

 

the developer of the site said that this is more than likely due to the shared hosting and has advised moving to a VPS hosted service...I have researched all of the performance enhancements you can make to magento and had the developer action these accordingly

 

just wanted some advice whether moving to a VPS is simply the answer or if there are other considerations?

 

moving to VPS is not cheap (Australia) if I go with the developers managed service and I am not technical enough to host the site on an unmanaged VPS...I have floated with the developer that he looks after the site (adhoc) even though it is hosted elsewhere and he seemed ok with this but it would be a risk

 

thanks in advance

 

Scott

11 REPLIES

Re: Site Performance with a lot of SKUs

Hi Scott,

Your developer is right. There is not much optimization you can do on a shared hosting account. Cheap option is to get an unmanaged server and hire server optimization guys from this forum to set it up for you . << Snipped >>

Anton Pachkine @ magento2.hosting : Magento Managed Package. Get your e-commerce health checkup at http://ecommerce.fitness

Re: Site Performance with a lot of SKUs

You may be able to keep the website in shared hosting if a caching system like LiteMage Cache or Varnish is available. 

 

If you decide to go with a VPS, I wouldn't recommend going with an unmanaged VPS as you will be responsible for not only the optimization or server management but also security, which is the most important aspect of a server. 

James Lee | Moderator • Magento Master
See My Recommended Magento Hosting & Security Tips

Re: Site Performance with a lot of SKUs


JLHC wrote:

You may be able to keep the website in shared hosting if a caching system like LiteMage Cache or Varnish is available. 


Setting up Varnish can be quite complicated. Like really complicated. However I strongly recommend adding FPC (Full Page Cache) for Magento CE installations as this can give you speed boost that can be measured in orders of magnitudes. Also it's just a matter of installing an extension.

Tanel Raja

Re: Site Performance with a lot of SKUs

 

first of all varnish and fpc cache is for page loading speed, using these when we have about 2-5 seconds from normal page loading speed.  here we have a problem that page just timeouts. so add some fpc = you will get the same result.

 

what you need to do is to check with your hosting provider - what exactly limits you have right now.

if there are some abnormal memory, cpu and php execution limits, slow hard drive, contention issues.

 

then you need to try to install aoe profiler and check any slow parts.

 

obviously if you trying to load +4000 options on product page - this is very stupid.

 

anyway vultr have cheap ssd vps in Australia.

------------
MagenX - Magento and Server optimization

Re: Site Performance with a lot of SKUs


Pronto wrote:
Setting up Varnish can be quite complicated. Like really complicated.

It wouldn't be complicated if the hosting provider support it out of the box, which is why I said if it is available. Smiley Happy

James Lee | Moderator • Magento Master
See My Recommended Magento Hosting & Security Tips

Re: Site Performance with a lot of SKUs

I don't know about your hosting provider, but mine certainly doesn't install necessary Magento extensions. Also they don't do configurations (such as hole punching) and related custom coding (when necessary)

Tanel Raja

Re: Site Performance with a lot of SKUs

thanks for your reply and I will certainly speak to our developer and hosting provider about your points

 

however, not knowing my site, business, local market and the reasons behind the large number of SKUs I find your comment about "this is very stupid" to be extremely naive for someone who is deemed to be an expert

 

anyway thanks again for your input

Re: Site Performance with a lot of SKUs

don't use vanilla Mysql. use MariaDB. this may not solve your issue but it's generally a good idea

فروشگاه آنلاین
فروشگاه ساز کاموا سرویسی هست که میتوانید بدون نیاز به استخدام طراح، فروشگاه خود را بسازید

Re: Site Performance with a lot of SKUs

exactly 

usability and market needs are two different things.

im sure there are lots of shops like yours but designed much better in terms of usability.

 

 

------------
MagenX - Magento and Server optimization