very slow order page

Hi @louisapple

the database upragde remind appear on top then i click and udate it with no issue

You mean the database is now updated and there were no issues, although in the scheduled log no scheduled Database upgrade actions were showing?

If yes, do you see any improvement in the speed of loading of the order page?

all updated now, and i delete 10000 past orders and it become 2 sec faster than before

Hi there,

Could you confirm if you deleted the 10,000 orders via WooCommerce > Orders screen or via the database?

This issue likely due to large size of order related tables such as wpnu_postmeta and wpnu_woocommerce_order_itemmeta.

I’d suggest getting in touch with your web host to see if they can help you tune MySQL performance.

I hope this helps! ??

i delete from back end NOT database, not sure it will reduce the load from database, any suggestions?

here is the screenshot from the resource monitor from my cpanel, it is over limit all the time

https://ibb.co/1LPLRjr

Hi @louisapple

Have you contacted your host about this as mentioned previously by Kaushik? They will be able to point you in the right direction regarding the database performance.

Please keep us informed.

yes the host did supply a guide

https://support.digitalpacific.com.au/en/knowledgebase/article/wordpress-cleaning-and-optimising-the-database

i would like to hear the opinions from woocommerce end as i think it should be a common issue when data accumulated. thanks

Hi there,

the host did supply a guide

That sounds like the way to go to clean and optimize your WordPress Database. When data grows, scaling your online store without affecting the performance becomes critical, and you shouldn’t overlook this option. Here’s a related article:

* https://woocommerce.com/posts/how-to-scale-woocommerce/

If you need an expert eye on this, you may want to speak to a database specialist. Please consider looking at our partner site https://www.codeable.io/partners/woocommerce/, where you’re able to hire from a curated list of experts who can help you.

Best regards.

my develop finally fix this for me , not sure what he did “It is a general bug in WP or Woocommerce, it is supposed to be fast but the bug makes it not work the way it is and I have fixed it. The issue is not obvious on normal sites, but it is quite obvious on your site with a lot of data”

Hi there,

I have exactly the same issue as yours, could you please get me in contact with your developer? I’m trying to fix this issue for months without success..

Hope to hear from you soon.

Thanks!

Hi @alex19977

I understand how frustrating this could be.

Since you’re not the person who originally started this topic then, per the forum guidelines, would you please start your own topic?

We’ll be more than happy to help there ??