• Resolved andyrjames

    (@andyrjames)


    Hi,

    Just updated to the latest version of woocommerce (6.0.0) . Front end still runs fine.

    Back end has slowed right down on every page. About 8 seconds to load.

    Order, plugins, products – all of them.

    All scheduled actions are cleared.

    This query runs 7 times on each page:

    SELECT wp_posts.ID
    FROM wp_posts
    LEFT JOIN wp_term_relationships
    ON (wp_posts.ID = wp_term_relationships.object_id)
    WHERE 1=1
    AND ( wp_term_relationships.term_taxonomy_id IN (2,3,4,5) )
    AND wp_posts.post_type = 'product'
    AND ((wp_posts.post_status = 'publish'))
    GROUP BY wp_posts.ID
    ORDER BY wp_posts.post_date DESC
    LIMIT 0, 1

    According to Query Monitor at just over 1s per query.

    Prior to update all was running fine.
    (There are over 400,000 products on the site.)

    Any help to resolve this?

    Cheers,

    Andy

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Woocommerce 6.0.0 slowing down admin’ is closed to new replies.