Super slow Woocommerce order page

  • Resolved james400studio

    (@james400studio)


    5 years, 2 months ago

    Hey,
    Opening orders in admin panel, adding new products etc takes a lot of time. It takes 3-4 minutes to open. I installed the query plugin to see whats taking so long.

    I have disabled all plugins except woocommerce, switched to 20/20 theme, reinstalled woocommerce and wordpress.

    This below query is taking 2-3 minutes
    ————–
    SELECT DISTINCT meta_key
    FROM wp_postmeta
    WHERE meta_key NOT BETWEEN ‘_’
    AND ‘_z’
    HAVING meta_key NOT LIKE ‘\\_%’
    ORDER BY meta_key
    LIMIT 30
    ——————-

Viewing 2 replies - 1 through 2 (of 2 total)
  • Rynald0s

    (@rynald0s)

    Automattic Happiness Engineer

    Hi @james400studio!

    What version of the core WooCommerce plugin are you currently using? Also, are you using Yoast SEO by any chance?

    Cheers!

    Rynald0s

    (@rynald0s)

    Automattic Happiness Engineer

    Howdy!

    We haven’t heard back from you in a while, so I’m going to go ahead and mark this thread as resolved. If you have any other questions please start a new thread.

    Cheers!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Super slow Woocommerce order page’ is closed to new replies.