1. Paul Aswad
    November 2, 2017 @ 3:31 am

    These are insane speeds for 800K products! I know for a fact WooCommerce slows down at less than 10k products, and that’s with a decent server!

    Have you tested how many visits / orders this setup can handle? Specifically orders, as these can end up slowing down the site (or the orders page)?


    • David H.
      November 2, 2017 @ 8:35 am

      re: visits, there’s no substantial limit here – scaling your visits is a matter of being able to quickly and efficiently populate your page cache. Users tend to hit similar pages, so a page-level cache significantly boosts the number of simultaneous visitors you can host. Ideally a page-level cache outside of WordPress like Varnish or Nginx fast cgi cache.

      re: orders, I have a client who makes about 10,000 orders per day. His site was slowing significantly and the issue was very similar – table scans were occurring. When you have eliminated table scans – like I have on FoundThru – it leaves plenty of room for your database to breathe and do its job properly. Table scans are not *meant* to happen. They are the last resort for badly designed queries/tables/indexes.

      My approach does involve adding some extra indexes to some tables and this does slow down *very slightly* inserting rows to those tables. e.g. If you have 2 extra indexes on wp_posts, thats 2 extra writes when inserting a row plus 2 index seeks (very fast) to find the location to insert.


      • Paul Aswad
        November 8, 2017 @ 10:44 pm

        OK. I am using the Jupiter Theme by Artbees on TF, and the theme is pretty well optimized for the standard gtmetrix / pingdom tests. Scores are good, loading time is good. And the theme is sold over 70k times, so a good user base.

        I use WP Rocket for caching, and noticed with Varnish, website crashes even when I tick the Varnish option. The theme has it’s own caching as well. I think this might be the issue.

        I’ll have to run some more tests and maybe keep things simple using other themes made for WC stores. Thanks for this review, and showing that even those Premium themes can be used!


Leave a Reply

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