Support » Plugin: Custom Order Numbers for WooCommerce » Extremely slow admin dashboard since update

  • Resolved mikefishtank



    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 2 years, 4 months ago by mikefishtank.
Viewing 6 replies - 1 through 6 (of 6 total)
  • Hi @mikefishtank,

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

    Chetna Bhutka

    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

    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 [] 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 2 years, 4 months ago by MechaDigital.

    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.

    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.

    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.

    Working much better for me now, thanks for the fix

    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.