Home›Support›English Support›[Resolved] Woocommerce orders admin and API VERY slow after WMPL installation
[Resolved] Woocommerce orders admin and API VERY slow after WMPL installation
This thread is resolved. Here is a description of the problem and solution.
Problem: After installing the WPML plugin on a WordPress site with WooCommerce and several other plugins, the client experienced significant slowdowns in managing WooCommerce orders and accessing the REST API. Despite attempts at database indexing and using object cache, the performance issues persisted, making the site almost unusable. Solution: We recommended that the client conduct specific tests to isolate whether the slowdown was solely due to WPML, a compatibility issue with another plugin, or another underlying cause. This step-by-step approach would help in identifying the precise problem and thereby facilitate a targeted solution. If the client finds that the performance issues continue after these tests, we suggest revisiting the configuration or potentially looking at alternative plugins for custom order statuses that might be causing conflicts.
Please note that this solution might be outdated or not applicable to your specific case. We highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If the issue persists, please open a new support ticket at WPML support forum for further assistance.
This is the technical support forum for WPML - the multilingual WordPress plugin.
Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.
Background of the issue:
I installed the WPML plugin a few days ago on a WordPress website that has WooCommerce with several plugins. The translation worked well, but managing WooCommerce orders became almost unusable, and access to the APIs became really slow after the installation. I tried database indexing and object cache, which improved the situation slightly, but it's still too slow. Even with automatic translation turned off and a server with a lot of hardware capacity, I can't get it to improve. I need guidance or I might uninstall the WPML plugin.
Symptoms:
WooCommerce orders admin and REST API access are very slow, taking at least 2 or 3 minutes to refresh orders after installing WPML.
Questions:
How can I improve the speed of WooCommerce orders admin and REST API access after installing WPML?
What steps can I take to resolve the slow performance issue caused by WPML?
thanks for the tip, very usefull tool.
A message appears with plugin called "WooCommerce Multilingual & Multicurrency" and taxonomy translations. We use a plugin called "custom order status" Version 1.1.1 | By Addify and it seems to be this the problem.
First I disabled all WMPL plugins, after that I deleted, and problems continued, after disable "custom order status" website comes to norma speed again.
This problem appears after I installed WPML plugin so, something is still wrong after taxonomy translations in our Database. query times goes from 280s to 4s after disable those plugin.
I upload an image from a notice that appears after WMPL installation.
WPML plugin and custom orders status in WOO are messing all the database.. this is what I saw.
I decided to change the custom order status for another plugin. I will updated you ASAP, but it seems to be a problem in your "WooCommerce Multilingual & Multicurrency" plugin with taxonomy translations.
otherwise website is unusable.
keep you posted and crossed finger to the other plugin with custom orders work...
I you have any insight please le me know
ok, new plugin for custom status order for woo working fine till now with translation. plugin name "Flexi Custom Order Status" by Tyche Softwares, still in testing.
I have a new report from your plugin sugestion "query monitor"
see details in attachment picture.
Function _load_textdomain_just_in_time was called incorrectly.
I would still need you to do the test I suggested and get back to me with results for each, as this would tell me more info that I need and help me decide on the next step.
This will tell me if issue you reported with the slow load is caused by only wpml, by compatibility issue or somethings else, then we can move forward to the solution once we know the cause of the issue.
Please try the suggestions and let me know how it goes.
