Viewing 15 posts - 16 through 30 (of 38 total)
  • Author
    Posts
  • #29075
    Profile photo of Chrisroll
    Chrisroll
    Participant
    #29076
    Profile photo of jean
    jean
    Participant

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

    #29077
    Profile photo of Robin
    Robin
    Keymaster

    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.

    #29080
    Profile photo of jean
    jean
    Participant

    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

    #29081
    Profile photo of Chrisroll
    Chrisroll
    Participant

    Perhaps a solution would be to upgrade your current hosting plan to pro hosting on justhost.
    If it’s like bluehost, they will charge only the difference (That’s what i did some months ago)…

    #29122
    Profile photo of jean
    jean
    Participant

    Thanks Chris, I’m stuck with them until 2019, so meanwhile it is something I should consider. I will ask for a quote!

    jean

    #29785
    Profile photo of Valentin Tabirca
    Valentin Tabirca
    Participant

    Hi,

    I have the same problems as Jean.

    As my site became larger, the speed got slower. I have installed over time Jetpac, WP Performance Booster, W3 Total Cache, Cloudflare CDN.  Without any of these, it is a disaster. I even moved my site to a different hosting for a few days to see if it is the same – it got worse (yay for Symbiostock hosting!).

    In a nuttshell, if i measure my site speed (front page and product page) with Pingdom or GTmetrics I get good speed like around 2 sec for front page and 0.9-1.2 sec for product page but I repeat the tests and I can get 5 sec front page or 5-11 sec product page. Then again good speed. It alternates.

    Visually it is the same. Now is good, then bad, then good again, etc. It is not constant. The front page second half – best sales and featured products panels load slow most of the times.

    Without the plugins I mentioned it is worse.

    The wp-admin dashboard is working ok with an exception: if I try to edit or delete 30 files at once I get an error – “A communication error occurred: Network error -The Web Server may be down, too busy, or …etc . Then I reload over and over but around 10 minutes my dashboard and site are down. But this also alternates with no errors sessions.

    What can I do?

    Thank you.

    #29786
    Profile photo of Chrisroll
    Chrisroll
    Participant

    Hi, Valentin,

    Did you tried to optimize your database on phpMyAdmin ?

    You can also install this extension to see if one plugin is causing slowness on your site : https://fr.wordpress.org/plugins/p3-profiler/

    #29787
    Profile photo of Valentin Tabirca
    Valentin Tabirca
    Participant

    I have Symbiostock hosting so everything should be optimized. Maybe a keymaster will help.

    As for the P3 the results are :

    Total Load Time: 5.4564seconds avg.

    Site Load Time: 1.7309seconds avg.

    Profile Overhead: 3.7256seconds avg.

    Plugin Load Time: 0.6567seconds avg.

    Theme Load Time: 0.6499seconds avg.

    Core Load Time: 0.2856seconds avg.

    Margin of Error: 0.1386seconds avg.

    (5.4564 observed, 5.3178 expected)

    Visits: 8

    Number of PHP ticks: 31,500 calls avg.

    Memory Usage: 86.84 MB avg.

    MySQL Queries: 143 queries avg.

     

    So it looks like the plugins are ok.

    And P3 for a product page:

     

    Total Load Time: 5.7521seconds avg.

    Site Load Time: 3.4149seconds avg.

    Profile Overhead: 2.3372seconds avg.

    Plugin Load Time: 0.5707seconds avg.

    Theme Load Time: 2.7203seconds avg.

    Core Load Time: 0.0741seconds avg.

    Margin of Error: 0.0498seconds avg.

    (5.7521 observed, 5.7023 expected)

    Visits: 2

    Number of PHP ticks: 25,735 calls avg.

    Memory Usage: 82.38 MB avg.

    MySQL Queries: 232 queries avg.

    #29788
    Profile photo of Chrisroll
    Chrisroll
    Participant

    I’ve aproximately the same numbers, except for theme Load time (0.21s on average) and Profile overhead (1.16s on average).

    Try to switch temporarely to another free WooCommerce theme to see if your slowness is theme related

    I’ve found this article too :
    https://www.wpoptimus.com/1980/simple-tweaks-speed-up-woocommerce/

    Hope it can help…

    #29789
    Profile photo of Valentin Tabirca
    Valentin Tabirca
    Participant

    I tried switching to another theme. The first page got better but it is practically empty so the result is not relevant. The product page got aprox 1 second more to load on average.

    I love symbiostock theme and I dont want to change it anyway.

    #29792
    Profile photo of Valentin Tabirca
    Valentin Tabirca
    Participant

    I want to ask a keymaster to check my problem. I want to hire a specialist to solve my problem. But first I have to exclude hosting issues, I want you to confirm me that everything is ok there.

    Thank you.

    #29793
    Profile photo of Robin
    Robin
    Keymaster

    Hey Valentin,

    I checked your site – as far as I can tell all pages are reasonably fast but the product page is quite slow. I believe this is due to the related products query because WooCommerce’s query for this (from early tests) was quite poor and was a bottleneck on speed.

    In fact, I am 95% sure this is the problem because you will notice that if you load a product page, then refresh it, it loads quite fast the second time. This is because WooCommerce cache’s the related products query so it does not do the query a second time for a certain period of time.

    We tried to fix this in early versions of Symbiostock but as WooCommerce keeps changing their code in unpredictable ways we basically retired that mechanism because it was too difficult to try to re-work their queries.

    However there may be third party solutions out there as this is not a Symbiostock issue but a WooCommerce one.

    As for the server, this is a bottleneck that would not be solved through server upgrading as you are not actually being throttled at all as far as I can tell: this is pretty much as fast as any CPU can process your related products query.

    #29794
    Profile photo of Valentin Tabirca
    Valentin Tabirca
    Participant

    Hi,

    Thank you.

    I will try to eliminate related and see how it works.

    How about the home page? – icon menu, featured and best sales are loading slow most of the times.

    #29795
    Profile photo of Robin
    Robin
    Keymaster

    For me it loads pretty much same as any other site – it could be additional plugins or something, but that’s pretty standard from what I see around. Have you tried a CDN?

Viewing 15 posts - 16 through 30 (of 38 total)

You must be logged in to reply to this topic.