Extremely slow site! [resolved]

[jeanParticipant]

I’m building a local picture library here

http://www.rudersdal.website/

and both the site and the dashboard activities are extremely slow.

I made also the mistake to upload the last woocommerce version, I saw too late it is not compatible with the present symbistock….

Would the optimisation (which may help the speed) of the data base be a wrong option? as Robin warned in a post dont upgrade the database in this case-

My questions

1) is “upgrading” the databse the same as “optimize” the data base?

2) what can I do to speed up my site (I guess some of the reason is the high number of pictures (12.000) )

Tahnks for yiour help!

jean

 

 

[jeanParticipant]

Thanks Chris, this is just what I did. I have downloaded the two plugins before posting. the W3 cache didnt change very much the speed. I have also deactivated all plugins I could without it helped. Now I’ll dare to try the optimize (and I should have a backup….)

I’ll come back when I have done the optimization….

 

[jeanParticipant]

I have done the optimization and things are qyite the same.

I suspect the number of files to be responsible of the issue, but I have no clue how this works. I’m with justhost. I’ll contact them to ask if they can help.

Thanks again Chris.

 

Jean

 

[jeanParticipant]

Thanks Georges, I think it hasnt chnaged anything for me, the site was slow before I updated woo commerce and it is still after, apart of that it runs normally.

[jeanParticipant]

I had some support from Justhost team but they concluded that “Our specialist also suggested to optimize the website.”
They guide me to
https://gtmetrix.com/reports/rudersdal.website/7uXB5d5w
and the diagnostic for the 2 main source of issues are :
Serve scaled images
Optimize images

Also they told me that
https://tools.pingdom.com/#!/baL87B/http://www.rudersdal.website/
says the speed of the site is OK….

I’m not sure what I can do with this, but the site is clearly slowed down by the number of pictures as I saw the speed decreasing while uploading more and more….

I think I will have to reduce the picture size and upload again…….

[jeanParticipant]

Thanks again Chris, I was on my Cpannel looking for the points you mentionned, I must say it is not obvious to me to find….

I guess however that when Justhost says it is not a server problem it is not (I’m probably also a bit naive….)

Jean

[Songquan PhotographyParticipant]

Jean,

You are not alone. My site slow down quite a lot when my images increase to couple of thousands. I guess the database file becomes larger in which case the queries take longer time.

I noticed your image file at home page is big. You home page loading size is 6M+. Try to drop the jpg quality as much as you can before seeing obvious artifacts. Home page is the most visited page. Faster speed help with user experience.

 

Cityscape and Travel Photography at http://bestcityscape.com

[RobinKeymaster]

I have checked out your website – here are my conclusions:

1) Image size is having little bearing on your load speed.

2) When I load certain pages (such as cart and checkout) it randomly hangs and randomly speeds up. This is highly indicative of a server that is overloaded.

3) It is highly unlikely that the number of products you have is causing the issue. They are not all loaded or parsed ever so there is no reason why that should be the case. Database queries may be a bit slower as your database gets larger but not as slow as your main page is, for example.

I cannot see what your WP Admin is like, but I do see that you have that massive category list on every page – remove that widget and see if it speeds up the front end.

If none of that works, then you can try disabling any extra plugins that could be adding overhead.

If that does not work, I would have to guess that your hosting solution, like many, is not geared with enough CPU and memory to run such a high intensity website and you are sharing your box with too many other websites.

These are the kinds of issues that are difficult to diagnose because most web hosts will not openly admit they have hundreds of other users on the same server because that is how they make their money.

You have the option of hosting with us if all else fails:

http://www.symbiostock.com/

Our hosting is made for Symbiostock sites.

[jeanParticipant]

Thank you Songquan , I’ll check that!

[jeanParticipant]

Thank you Robin, I would be sad to get rid of may categories, but I’ll check if this is the issue.

I’ll seriously consider to change from justhost if I cannot solve the issue. Unfortunately I have signed and paid for 2 years….

But I shall keep this in mind!

 

[RobinKeymaster]

You dont have to get rid of categories – just get rid of the widget that is listing them all on every page.

That’s the problem with certain web hosts – you get a deal for 2 years but then you’re locked into an oversaturated box with poor customer support.

[jeanParticipant]

Thanks Robin, I have tested and removed some menu widgets and this helps, I will have to find another way to bring my menus.

This said it is extremely slow (this didnt change) on the Adm. side.

For ex it takes 2 minutes and 30 seconds (!!!!) to delete 30 files under Symbiostck/media menu.

Is this linked to te number of pictures? (it was not slow at all when I started to build up…)

 

[jeanParticipant]

Thank Chris, a lot of ressource there! I dig into them. Thanks for this very useful post.

[RobinKeymaster]

Hey Jean – it is linked to the number of pictures but not in the way you might think. Basically when the number of products is small, the overhead is low because each query to the database is querying from a very small database.

But when you have thousands of products you are then querying a large database. This requires both CPU and Memory allocation from your web host. Some webhosts will restrict this (memory more than CPU) and as a result of this your site will start to slow down for each query. It’s not querying every image, but it still needs to query a large database.

Further, Symbiostock does not add much overhead, if at all, to your main product database. It runs almost exclusively through the base WooCommerce system.

WooCommerce has an article here:

https://docs.woocommerce.com/document/how-many-products-can-woocommerce-handle/

which basically outlines what I’m saying here. Overall, there is no way to circumvent this issue if the web hosting platform you are on does not provide sufficient resources. There is no level of optimization or fixing you can do if the backend is slow. You must have a more powerful hosting solution.

Symbiostock should not be run on an entry level hosting solution. You will hit issues inevitably and are in essence gambling on the hope that you won’t.

[jeanParticipant]

Ok thank you Robin, this is a good and a bad new to me. I have indeed paid already for the next year and it is a big budget compared to the sales… so I will have to wait before moving…but I appreciate the time you all have spent to help!

jean

[Author]

Posts