Skip to content

6 Comments

  1. Dave H.
    March 11, 2022 @ 1:43 pm

    My bad – I’d updated our demo sites where we test everything to WooCommerce 6.31 which is actually the latest version and this issue is already fixed.

    Foundthru was still on an older version which I’ve now updated and confirmed this issue is also fixed there.

    Reply

  2. Dave H.
    March 11, 2022 @ 2:01 pm

    Spoke too soon again – 6.31 still has this issue. 27 seconds added to wp-admin. Maybe it will go away when the new Product Attribute Table has been created.

    https://i.imgur.com/oCs3IQq.png

    I’ll report back once that’s happened.

    Reply

    • Phil
      May 3, 2022 @ 9:42 pm

      Did the issue go away after the Product Attribute Lookup Table was created?

      Reply

      • Dave H.
        May 5, 2022 @ 10:20 pm

        It still hasn’t completed on my million product site – I increased the batch size to 10,000 – it should be done soon. I don’t like how they build these tables – they make them super reliable on every site but as a result, they take ages to build.

        My tables use MySQL 8 features (recursive CTEs) to make building and maintaining these tables really fast.

        Reply

  3. Mahboob
    August 30, 2023 @ 2:54 pm

    Hi Dave,
    I am a WordPress and Woocommerce dev. Recently I have been working on a website where we have a large number of products.
    We have used woocommerce widgets on the blog page sidebar. It takes 8-10 seconds for woo-commerce slow queries to get widget HTML results. Please check this page https://www.kideno.com/en/what-memories-should-you-aim-to-create-for-your-child/
    This happens whenever we are accessing not cached page.
    Will your plugin help us to reduce query time?

    Regards
    Mahboob

    Reply

    • Dave H.
      August 30, 2023 @ 6:57 pm

      You need my Super Speedy Filters plugin. I tried originally to bake everything into Scalability Pro but in the end Search and Filters had to be separate plugins. You’ll also need redis-cache.

      Reply

Leave a Reply

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