Hello,
Thanks for the feedback. Just to be precise, you created 3700 terms, not taxonomies, right? If that’s the case, in which taxonomy? The native product_cat Woocommerce taxonomy?
Can you please tell me on which page do you have that slow down? Admin Product Edit? Front Product Single?
If the page is in admin, is there any ACF fields there? If yes, which one (Name, type, data)?
The debug log you shared is saying the query took 0.05 seconds to execute, so it’s most likely not tied to that one. Can you please share a full screenshot of the Query Monitor?
Regards.
Hello,
Sorry for not being specific enough.
The 3700 are product categories (Woocommerce -> products -> product categories).
The page that slows down is when I click on product -> modify, not on quick edit.
All this is in the admin part in the backend.
Yes I have ACF fields, there are 29, 6 drop-down lists, 6 text fields, 3 date fields, 3 checkbox fields, 1 image field, 1 gallery field, 1 button group field, 6 groups with each about 150 fields of taxonomy terms.
I have no slowdown elsewhere, in the backend or the frontend, except when I want to modify a product in the admin part.
I specify that I am on a very good server with good resources.
I managed to speed up loading (I gained 30s out of 70s) with the code you give on wordpress to deactivate modules: How to disable specific ACF Extended modules? (Dynamic Post Types, Taxonomies, Options Pages etc…)
thanking you for your help
Hello,
The problem come from the “Taxonomy Terms” fields you have in your Product Edit screen. If you temporarily disable the field group that contain those fields, you’ll see a performance improvement. This is why when you disable ACF Extended, performance gets better, because the “Taxonomy Terms” field doesn’t exists anymore.
The thing is, Taxonomy Terms field load all terms of the allowed taxonomy on page load. In your case, the taxonomy Product Category has 3.7k terms. A solution is to use the field as a Select and use Asynchronous Load setting. But the Async Load setting isn’t effective for the moment, I have to implement it first. it’s on the roadmap.
Meanwhile, a workaround is to use the native ACF “Taxonomy” field, which can be used as a Multi Select and has a built-in Asynchronous Load setting.
Note: Enabling/Disabling modules should not alter performance. I don’t know which modules you disabled, but it is most likely an unrelated side effect.
Regards.
Hello,
I just commited an update for the Taxonomy Terms field which includes a working Asynchronous Load setting. It will be published in the next patch.
In the meantime, you can download the file and replace it in acf-extended/includes/fields/field-taxonomy-terms.php. Here is the new version: https://raw.githubusercontent.com/acf-extended/ACF-Extended/master/includes/fields/field-taxonomy-terms.php
Then, you’ll be able to set the field Type as “Select” and use the “Use Ajax to Lazy Load Values” setting in your Taxonomy Terms fields. Screenshot: https://i.imgur.com/m19CVqB.png
This will drastically improve performance on your Product Edit screen.
Regards.
Hello,
Thank you very much for your responsiveness and your precious help, I will do what you say and I come back to you to give you the result.
Thanking you again
Hello,
I tested the new code, I can activate Ajax for taxonomies terms, but only when I choose “drop-down list” in -> customize the appearance of the fields, and not for -> checkbox check. Maybe it is not possible?
Attached are screenshots for both versions.
screen4
screen5
Thanking you for your help
Hello,
Yes, the Lazy Load aka “Asynchronous Load” works only with “Select” Appearance, and is not available for checkboxes/radios, just like any ACF field.
Regards.
Hello,
Ok, thank you again for your help.
Hello,
You’re welcome, can you please tell me if the Select + Lazy Load fix your performance issues in the Product Edit screen?
You also forgot to answer me to that question:
Note: Enabling/Disabling modules should not alter performance. I don’t know which modules you disabled, but it is most likely an unrelated side effect.
Thanks.
Regards.
Hello,
I come back to give you news.
After having spent everything in Ajax, I found a very honorable loading time (between 2s and 3s).
Thank you for your help and good development
You also forgot to answer me to that question:
I put everything back and it works very well, certainly another effect that has nothing to do with this plugin.
Hello,
Okay! I’m glad to hear it now works as expected!
Have a nice day.
Regards.
