Speeding up WooCommerce products admin & database

Hi there,

I have a WooCommerce store integrated with an EPOS via an API. I’ve just imported the products – all 33,000 of them – and need to categorise them.

When I bulk edit ~50 products in the admin an select a category, it takes around 50 seconds to save the category assignment. I’ve got 33,950 left to do!

I’ve debugged using Query monitor and the whole process of updating products is just very heavy. I’ve added an index to post_meta as:

ALTER TABLE demo . wp_demo_postmeta
ADD INDEX post_meta_key (post_id ASC, meta_key ASC);

which helps, but it’s still very slow.

Where should I look next? How can I improve the admin performance?

The front-end is fine, W3 Total Cache does the job very well.

https://ww.wp.xz.cn/plugins/woocommerce/