[Waiting for user feedback] So disappointing performance due to WPML
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.
Elementor users - please update WPML to the latest version to maintain compatibility. More details here - https://wpml.org/changelog/2024/12/wpml-4-6-15-critical-update-for-elementor-sites/
Background of the issue:
I've struggled in the last 1 month with my customer who keep complaining about the performance and the slowness of the website. We decided to remove the 2 extra languages and kept only the default English. Once this was done, the website performance improved. Now, I am facing an issue with duplicated data due to the previous 3 languages setup and need to clean up only the duplicated Products, keeping only the English language products.
Symptoms:
Most of the data is duplicated due to the 3 languages, and I am not able to remove the duplication of the Products.
Questions:
How can I clean up only the duplicated Products and keep only the English language products?
Yes, as I noted before in the Database, that there is no record of any translations (in the icl_translations table only English content is listed), so if non-English content has been left behind (e.g. in wp_posts) there is no easy way of identifying it to delete it.
The first step is not working for you since the first time the languages were deleted weren't done properly,
If you don't have such a backup it may be possible to write a short script that deleted any posts that were duplicates (rather than translations) as there may be a leftover trace in wp_postmeta that identifies such posts. But that's the only thing that could be automated. If there is translated content (rather than duplicated) there is no longer a record of that, and no way to know what language some content actually is.
Please get back to us if you got such backup, as this is the fastest solution, if not, we will work in a slower solution that require some manual work,
Okay this backup works well, I'm deleting both Hebrew and Arabic content, could you please confirm that you no longer need WPML content and that I can delete everything related to WPML ?
