Extremely slow admin dashboard since update

  • Resolved mikefishtank

    (@mikefishtank)


    3 years, 2 months ago

    Help!

    I updated the plugin yesterday and now the entire admin dashboard takes over 2 minutes to load every page or times out completely.

    I also get this wordpress notification message every time I load an admin page even though I have closed it multiple times:

    Database updated successfully. In addition to new orders henceforth, you can now also search the old orders on Orders page with the custom order numbers.

    • This topic was modified 3 years, 2 months ago by mikefishtank.
Viewing 6 replies - 1 through 6 (of 6 total)
  • chetnapatel

    (@chetnapatel)

    3 years, 2 months ago

    Hi @mikefishtank,

    Could you upgrade the plugin to the next version & check the problem? This issue should be fixed in this version released today.

    Regards,
    Chetna Bhutka

    MechaDigital

    (@jasonkobies)

    3 years, 1 month ago

    I’m getting the same thing on version 1.3.3.

    Here’s what query monitor is showing. This process is taking ~6 seconds to happen

    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
LEFT JOIN wp_postmeta
ON (wp_posts.ID = wp_postmeta.post_id
AND wp_postmeta.meta_key = '_alg_wc_custom_order_number' )
LEFT JOIN wp_postmeta AS mt1
ON (wp_posts.ID = mt1.post_id
AND mt1.meta_key = '_alg_wc_custom_order_number_meta_key_updated' )
WHERE 1=1
AND ( wp_postmeta.post_id IS NULL
AND mt1.post_id IS NULL )
AND wp_posts.post_type = 'shop_order'
AND ((wp_posts.post_status <> 'trash'
AND wp_posts.post_status <> 'auto-draft'
AND wp_posts.post_status <> 'wc-wfocu-pri-order'))
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 1 /* From [sitename.com/wp-admin/plugins.php] in [/nas/content/live/m***********g/wp-content/plugins/custom-order-numbers-for-woocommerce/includes/class-alg-wc-custom-order-numbers-core.php:327] */
    • This reply was modified 3 years, 1 month ago by MechaDigital.
    Vishal Kothari

    (@ashokrane)

    3 years, 1 month ago

    Hi @mikefishtank,

    Thank you for pointing out this query. I’m going to ask my team to have a look at this bug. We will keep you updated on the same.

    I’m assuming here you have already updated the database from the notice you get after updating the plugin.

    Vishal Kothari

    (@ashokrane)

    3 years, 1 month ago

    Hi All,

    The issue has been fixed. Here in the below link, we uploaded the modified file of our plugin which you can upload on your store in the respective folder.

    Link: https://www.dropbox.com/s/yd4loxwqz4z6a7r/class-alg-wc-custom-order-numbers-core.php?dl=0
    file name: class-alg-wc-custom-order-numbers-core.php
    file path: wp-content\plugins\custom-order-numbers-for-woocommerce\includes

    Do let us know how it goes.

    MechaDigital

    (@jasonkobies)

    3 years, 1 month ago

    Working much better for me now, thanks for the fix

    Vishal Kothari

    (@ashokrane)

    3 years, 1 month ago

    That’s great @jasonkobies, Thank you for confirming here.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Extremely slow admin dashboard since update’ is closed to new replies.