backend edit products extremely slow, 80 seconds

Hi @nossileee,

It’s odd to hear the time taken to load the product page is close to 80s and the speed improved only after selecting the product editor to the New Product Form.

Could you please send me a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support” (after you scroll down a bit)”. Once done, please paste it here. Make sure to remove or hide any sensitive information from your System Status Report

Looking forward to your reply!

Hello!

Here are some considerations:

1- I deactivated all plugins, left only Woocommerce + Elementor activated and the slowness continued in the same way.

There doesn’t seem to be any conflict.
The strange thing is that a few weeks ago it was normal, then it stayed like that and didn’t get any better.

Orders were also very slow, I resolved them with HPOS, but as the products are still beta and still have bugs, it is not possible to activate them permanently.

Yes, follow the generated report.

https://gist.github.com/nossileee/a1f8bf9db75d4cdbef600c1b4453f03b

Hi there,

Welcome back! Thanks for testing and sharing the details.

Yes, follow the generated report.

The System Status Report and you resources looks good.

I deactivated all plugins, left only Woocommerce + Elementor activated and the slowness continued in the same way.

There doesn’t seem to be any conflict.
The strange thing is that a few weeks ago it was normal, then it stayed like that and didn’t get any better.

Did you try deactivating Elementor and switching to the Storefront Theme theme? It does sound like an update is leading to the increased loading time.

Can you please check this?

Also, do you see any fatal errors under WooCommerce > Status > Logs?

Let us know what you find!

Hello!

Yesterday I did several extra tests.

I cloned the site to a .teste subdomain and cleaned many tables, from 806 to 182, repaired them, optimized many times.
Original base:
https://imgur.com/Aa4Idy4

Clean and optimized base by me:
https://imgur.com/30tPFMr

I also deleted more than 600 old orders with canceled status, optimized tables again, to reduce size, still the same thing….

Just now, I deactivated Elementor, tested it, it’s still slow.
https://imgur.com/sAIpk8m

I installed the Storefront theme, tested it, it’s still slow…
https://imgur.com/4cfjp5K

You can see it here:
https://teste.boottrainingbrasil.com.br/

I almost exhausted my possibilities.

What I’ve been trying to do for almost 2 hours now (or it seems like it) is the Woocommerce tools.

Woocommerce -> Status -> Tools -> Generate -> “Table for quick product lookup” and also “Regenerate product attribute lookup table”

But it seems very long….because it’s been about 2 hours and it doesn’t seem to finish.

This last part, I ran both on the main site and on the clone/test site.

When I refresh the screen the message still appears: “The product attribute lookup table data is being recreated”

What else can we do?

If you want, I can give you access to the clone/test site, I thought that if I cleaned the DB, I could solve it, I spent many hours on this, removed some, tested, it was still slow, removed others and went like this. (Note: there were a lot of lost tables, because years ago I used a snapshot plugin and there were a lot of tables left, but even cleaning it, it didn’t change anything).

Hello!

Do you have any instructions?

It seems to me that all of this is linked to HPOS in some way.

Because orders were also extremely slow.

I resolved them by activating HPOS.

But now, the same slowness is in the products.

I’ve done everything, as I said above… I cleaned the database, optimized tables, deleted more than 5000 canceled orders, everything to optimize speed, but nothing works.

It seems that there is some “lock” that takes a while to load the product page.

A while ago I made a clone of this site, and deleted all orders, customers, etc., left it clean, to be used only for wholesale customers, and on this one, everything works perfectly.

Only on the official website, which has many orders, customers, etc., does this happen.

Both have the same product registrations.

Thanks.

I just installed this plugin, made the adjustments it indicated, and like MAGIC, IT WAS PERFECT AND OPENING QUICKLY!

https://br.www.ads-software.com/plugins/index-wp-mysql-for-speed/

View post on imgur.com

Hi @nossileee,

But now, the same slowness is in the products.

I’ve done everything, as I said above… I cleaned the database, optimized tables, deleted more than 5000 canceled orders, everything to optimize speed, but nothing works.

It seems that there is some “lock” that takes a while to load the product page.

Hmm, it does appear that the size of the product data was contributing to the longer loading times.

I’m glad to hear that you found a solution by incorporating the plugin: https://www.ads-software.com/plugins/index-wp-mysql-for-speed/ — I appreciate you sharing this information. This will be beneficial for other websites with extensive product storage experiencing similar performance issues. Moreover, great job on successfully addressing this matter, and thanks again for sharing the resolution steps.

Should you have any further questions, please feel free to reach out!

All right, Solved!

I even installed these plugins on all other sites and optimized the database, it helps make the query lighter, using less server resources.

Thanks.

Hi @nossileee ?? Awesome, glad to hear that!

Thanks for updating and sharing this with us and the community here! ??

Hello!

I would like to know what has changed in Woocommerce.

On this example site that I gave above in the report, I had Woo 8.7.0 for a long time, and everything was fine and FAST to open and edit orders.

But TODAY, I decided to update to Woo 8.8.3 and I had the sad misfortune of receiving the SAME SLOW TIME when simply opening an order.

I redid the process with the “Index WP MySQL For Speed” plugin, that is, I undid the keys optimization, and redid it again, and I had the sadness of NOTHING HAPPENING, that is, it seems that now, in Woo 8.8.3 it is not possible to optimize the table so that orders can be opened quickly.

I need help from you, as it is impossible to work with slow requests like this.

I am available to assist you with this solution.

Or even, some way to downgrade Woo (but I don’t see that as a sustainable solution), but if necessary, resolve it quickly, until they find a definitive solution.

Thanks.

It’s actually a “little” worse.

The server is giving an error because I can’t even open the order, I ended up closing the window now, but in short, I can’t even open the orders anymore after updating from Woo 8.7.0 to 8.8.3.

Need help.

Today, I tried again to optimize the DB, redo the keys using the “Index WP MySQL For Speed” plugin and NOTHING worked.

I installed WP Rollback, returned the version to Woo 8.7.0 and by magic, the requests started working again quickly, before in fact, I couldn’t even edit the requests.

How to resolve this?

Hi @nossileee,

Just to confirm, you are facing slowness with WooCommerce 8.8.3 and with the orders table, right?

If so; can you please go to WooCommerce > Settings > Advanced > Features and check if there any orders that are in sync with the post table?

The WooCommerce 8.8.3 did not have changes related to database. Are you using the legacy API? If so; the Legacy REST API?Plugin will be automatically installed with the update to 8.8.3 but that will not affect the speed of orders.

Looking forward to your reply!

Friend, you took 10 days to respond and didn’t say anything hehe.

There is a problem….

I hadn’t left the orders in sync, that day I ended up scheduling them to sync again to see if anything changed, but nothing changed.

It only resolved with the rollback to woo 8.7.0.

And look… I don’t know if you work with Woo, but there are already problems identified about this, huh…

@olliejones is part of this, who is the programmer of this plugin -> Index WP MySQL For Speed, he even created another plugin to solve precisely the problem I reported.

Hi @nossileee,

Thanks for getting back and sharing all those details.

I hadn’t left the orders in sync, that day I ended up scheduling them to sync again to see if anything changed, but nothing changed. It only resolved with the rollback to woo 8.7.0.

Thanks for confirming that the order sync was completed and you still faced the issue.

I understand that the performance of the order page is affected by the issue detailed here: GitHub Issue #47212 (even after the orders have synced completely). The fix for this issue is included in WooCommerce version 8.9.0 (#46476), with further iterations in version 9.0.0 (#46985).

In the meantime, we recommend trying the plugin created by @olliejones, which addresses this issue: Fast Woo Order Lookup. Thank you, @olliejones, for this valuable contribution.

Please try the plugin with WooCommerce versions 8.8.3 and the upcoming 8.9.1 release. Let us know if you continue to experience any issues.

Thank you for your patience and cooperation.