Dave Hilditch

13 Comments

  1. siparker
    March 11, 2015 @ 6:22 pm

    Hi
    id be interested in seeing what the Woocommerce bits are that cause this issue and if we could put a plugin together to overwrite these functions to limit the damage it can do in terms of times taken to process stuff.
    either that or is it possible to move some of these php functions out into asyn to make them work without affecting the front of the site?

    Im looking at using woocommerce for some affiliate sites now and would be very interested in your thoughts.
    Page bookmarked for future ref also.!! thanks for the github repo for setup.

    Reply

    • Dave Hilditch
      March 11, 2015 @ 8:35 pm

      Hi – I went through quite a bit of working optimising the underlying SQL queries until I then discovered you can simply remove them – they’re not required at all as all they’re doing is counting products in each category – that happens EVERY page load and updates the database – very inefficient.

      Anyway – to stop this abominable code from running and seriously speed up your large woocommerce sites, add this line to your functions.php file:

      remove_action( ‘woocommerce_before_shop_loop’, ‘woocommerce_result_count’, 20 );

      Reply

  2. Optimizare SEO
    May 12, 2015 @ 10:30 am

    Very good post. Well done

    Reply

  3. Svetoslav Nikolov
    May 14, 2015 @ 11:37 am

    Hello,

    Thanks for sharing. Which file exactly has to be edited.

    Thank you.

    Reply

    • Dave Hilditch
      May 14, 2015 @ 12:50 pm

      You don’t need to edit a file. Run the first commands from the shell – SSH – log in using Putty or similar. As for the crontab file, you just run the crontab -e command from the shell and it will let you add the cron job.

      Reply

  4. Nikhil
    May 15, 2016 @ 8:13 pm

    Hello,

    The improvement in your client’s site page load time from 185 Seconds to 10 Seconds is great! Did this happen “just” by the installation of HHVM or you had to make some other optimizations?

    Eager to hear from you.

    Thanks!

    Reply

    • Dave Hilditch
      July 4, 2016 @ 4:18 pm

      In that case, yes, it was HHVM. For them, they were using simple affiliate products (not variable products). WooCommerce was fetching EVERYTHING and then parsing it all using PHP. I didn’t speed up the database bit for them but the HHVM speeded up the PHP parsing.

      Reply

  5. Vibhor
    October 18, 2016 @ 6:57 am

    can you give me the site where more then 100000 SKU are there using Woo Commerce. that would be great help

    Reply

  6. ManyPetProducts
    February 7, 2017 @ 9:14 am

    11 seconds is still slow…

    Reply

    • Dave Hilditch
      February 19, 2017 @ 6:00 pm

      I agree – that’s why I’ve built the Rocket Stack and Scalability Pro – both of these combined, along with avoiding some bad plugins, ensures sub-second speed everywhere

      Reply

  7. Krunal SHAH
    April 1, 2017 @ 8:40 am

    11 second is still very low in today’s world. I am planning to start an ecommerce website with over 20,000+ products and over 300,000 pages.

    Do you still recommend woocommerce for such big website?

    Reply

    • Dave Hilditch
      April 4, 2017 @ 7:45 am

      Yes sure – there are understandable reasons why people think performance is poor with wordpress, but really it’s just a matter of eliminating the poor code or rewriting it.

      My plugin Scalability Pro does that.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *