[Resolved] Wpml has been very very slow lately in back end
This thread is resolved. Here is a description of the problem and solution.
Problem: If you're experiencing very slow backend performance with WPML when updating products, taking up to 20 seconds, we have investigated this issue.
Solution: First, check your database's
_options
table for any unusually large entries that could be affecting performance. You can use the following SQL query to identify large autoloaded options:
SELECT option_id, option_name, sum(char_length(`option_value`))/1024 as size FROM `wp2x_options` WHERE `autoload` = 'yes' GROUP BY option_id ORDER BY size DESC
If you have tested and the issue persists, or if this solution doesn't seem relevant to your situation, please open a new support ticket with us for further assistance: Contact WPML Support
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.
Hello. I have developed a site for almost 1,5 years. The host provider is on of the best in sweden with top quality and speed servers. But now we have detected that wpml has been very very slow lately in back end. So when we updating a product, it is taking up to 20 seconds! We have been running speed tests and analysis, and sadly, wpml is the one plugins that slow things down in back end. There has not been an issue with WPML before, so is there anything you guys can do to fix this issue?
Please go to WPML->Support->Troubleshooting and run "Cleanup and Optimize String Tables"
- Does that help?
What is the current impact of WPML on the page loading time?
(When you deactivate/activate WPML)
For that, you can use the simple Chrome extension Page Load Time (hidden link) to measure loading time.
NOTE: During these tests please ensure that any cache plugin is deactivated. Also if possible it's best to perform these tests on a staging environment, if that is not possible we recommend ensuring that you have a working backup.
Typically up to 20% increase in load time is expected as WPML is a more complex plugin that requires more resources, I do see here we might have an increase of around 30% which we can investigate further, but I would like to first ensure if this is a global issue in your environment or just related to a specific product.
Is this load issue happening with just this one product or multiple products?
Ok good to know that wpml generally increase load time by 20%.
And yes, this is happening on all product updates, so its just not one products that is causing this crazy load time. It is every update you do on a product.
I can see that i cant add access to you/your team to our dev site in this message, but if you look into my previous support history, you will have an access link to the dev site where you can investigate this further. You have my permission to on the dev site: deactivate plugins, activate plugins, add new plugins, add code snippets and so on to investigate this load time issue on product updates.
At the moment our team is not able to easily reproduce the performance issue experienced on your site, we are still working on this and once I have more feedback I will update you here.
After reviewing this with our dev team the only thing that they can see that could be affecting performance is that a duplication process is starting (synchronization with duplicates) once you update a post in the default language and then the cache is cleared (wpml cache).
Probably this is what causes the slowness you are noticing,
Breaking the duplication link will allow for the update to be a bit faster.
Other than that we did not see anything else that could be responsible for the slow updating time from WPML's side.
I can see on the test site that you had access to, that there is an improvement in speed when updating products, so i guess that was one of the big things effecting the speed.
Since the big issue is on the live site (ferrita.com), i wonder if this is something we can fix ourselves? Or can i give your 2nd tier support access to the live site so they can fix the duplication process on the live (ferrita.com) as well?
