Extremely slow admin dashboard since update

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

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, 7 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.

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.

Working much better for me now, thanks for the fix

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