backend edit products extremely slow, 80 seconds

Hello!

I installed the Fast Woo Order Lookup plugin, but I was still on version 8.7.0, I had a lot of problems after doing this downgrade, and I don’t want to go through that again, it was really delicate.

I will only update Woo when I have the version with all this fixed, probably in version 9.0.0

Anyway, thank you for your attention.

Happy to help!

There was definitely a performance regression in WooCommerce 8.8.3, for what it’s worth. That regression disrupted stores with many orders. Root cause: A SQL query was added to fetch the distinct non-private meta_key values from wp_wc_orders_meta. The way it worked was very slow. (A full scan of the table is required to satisfy the offending query.)

Changing it to use the same pattern as a similar query in core resolved the problem. Here’s the place in my plugin that patches the query. That change is in WooCommerce’s 9.0.0 code. (not 8.9.0)

https://github.com/OllieJones/fast-woo-order-lookup/blob/3e9f25347cc96e43f166029e49e42e51816d5bb9/fast-woo-order-lookup.php#L345

If WooCommerce were my project, I would make an emergency patch release to mitigate this regression; it is serious, but only for the largest users of WooCommerce, and my fix is a miserable hack.

I would also adopt routine tests against one or more very large stores (many orders, products, variants, users).

• This reply was modified 10 months, 2 weeks ago by OllieJones.

Hi @nossileee,

Thank you for getting back to us, and thanks to @olliejones for sharing the details!

We understand how frustrating it can be to experience slow performance on the order screen. Team is actively addressing this issue. We implemented one fix in the recent WooCommerce 8.9 release, and a second, more comprehensive fix is scheduled for WooCommerce 9.0 next month.

While the second fix will provide a more complete solution, the initial fix should improve performance for most sites.

Thanks for your patience while we address these issues. Let us know if you have any further questions!

@sandipmondal Hi there – has this issue been fixed in release 9.0? As I cannot see anything related to it inside the changelog, or am I missing it?: https://github.com/woocommerce/woocommerce/blob/trunk/changelog.txt

We have a shop with 400k+ orders and it is taking 30+ seconds for an order to load with wooc ver 8.9.3 – opening 5 order pages at once causes EC2 CPU to go from 10 to 60%. I cannot express how urgent this issue is and unfortunately the fix supplied here by Ollie is not working for us using 8.9.3. Thanks in advance, I really appreciate it, Sebastian

Hi @nyhotdogman,

Yes, the fix is included in WooCommerce 9.0 as you can see on the changelog line 207.

Can you please update WooCommerce to 9.0 and check? (Please make sure to take a full backup of your current setup before making any changes. A backup never hurts)

If you’re still seeing issues; please contact us at WooCommerce.com > My Account > Support. Please include a link to this forum thread as well while contacting us.

We will be happy to help you further!

@sandipmondal thanks a lot for your quick response; I missed that entry in the log, sorry! We will update and I will reply in case we still have issues. Thanks!

Hi @nyhotdogman,

No worries. Glad to help!

We will update and I will reply in case we still have issues.

Sounds good! If you face any issues; please feel free to contact us at?WooCommerce.com > My Account > Support. Please include a link to this forum thread while contacting us so we can keep track of the request.

Let us know how it goes!