Our site is very slow because of the WPML Media Plugin

This thread is resolved. Here is a description of the problem and solution.

Problem:
The client's site is experiencing slow performance, taking nearly 13 seconds to render each page, potentially due to the WPML Media Plugin.
Solution:
We recommend creating a new staging site and performing the following steps:
1) Navigate to WPML >> Settings >> Media Translation.
2) Click on the Start button and wait for the process to complete.
3) Go to WPML >> Support page, and click on the Troubleshooting link.
4) On the Troubleshooting page, click on the following options in the Clean up section, waiting for confirmation after each:

Clear the cache in WPML
Remove ghost entries from the translation tables
Fix element_type collation
Set language information
Fix WPML tables collation
Assign translation status to duplicated content
Fix terms count
Fix post type assignment
Cleanup and optimize string tables

If this solution does not resolve the issue, please open a new support ticket with us.

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.

Tagged: Performance

This topic contains 58 replies, has 3 voices.

Last updated by Bigul 1 year, 8 months ago.

Assisted by: Bigul.

Author	Posts
January 15, 2024 at 12:23 pm #15185017
prajwalM	Yes, you can test by switching the Theme to default. This is an Ubuntu Server running the latest Plesk version. 8 Core. ATS Hosts this Virtual Server
January 15, 2024 at 2:00 pm #15185654
Bigul	Hello, Thank you for the feedback. So you are using a dedicated or a VPS server for this website, am I correct? -- Thanks! Bigul
January 15, 2024 at 2:10 pm #15185735
prajwalM	Dedicated server for this website
January 16, 2024 at 6:50 am #15187831
Bigul	Hello, Thank you for the updates. We will do detailed performance testing on the staging site - hidden link and get back to you as soon as possible. Please wait. -- Thanks! Bigul
January 16, 2024 at 7:04 am #15187857
prajwalM	okay. Thank you so much
January 17, 2024 at 1:45 pm #15195224
prajwalM	Any Update on this task?
January 18, 2024 at 2:46 pm #15200744
Bigul	Hello, I had a few rounds of testing on the staging site. It shows the expected results after the following steps. 1) Visit WPML>>Settings>>Media Translation 2) Click on the Start button 3) Wait until the process complete 4) Go to WPML>>Support page, click on the Troubleshooting link (blue link in the middle of the page) 5) On the Troubleshooting page, please click on the following options of the Clean up section. Wait for confirmation of processing after each one. - Clear the cache in WPML - Remove ghost entries from the translation tables - Fix element_type collation - Set language information - Fix WPML tables collation - Assign translation status to duplicated content - Fix terms count - Fix post type assignment - Cleanup and optimize string tables Also, I have activated Query Monitor to check the slow queries. Most of the pages(frontend and backend) are loading in one second. Please check the attached image for more details and let me know your feedback. -- Thanks! Bigul
January 19, 2024 at 11:33 am #15204537
prajwalM	ok thanks for your support. so as per the above information we need to only do the first 5 steps only right
January 19, 2024 at 11:40 am #15204578
prajwalM	Hi Bigul, If there is any risk? Since our live site is so large with much content, it will be hard to tell right away if something gets messed up.. means after performing this activity can we face any risk? Regards, ATS Team
January 19, 2024 at 11:50 am #15204642
prajwalM	With your deep experience in WPML, what is your feeling was the root cause of this issue? How do you think it occurred? It is just for information
January 19, 2024 at 12:38 pm #15204909
prajwalM	Checked the staging site and you deactivated most of the plugins & right now language switcher is not visible. I already reactivated the main plugins now
January 19, 2024 at 1:02 pm #15205069
Bigul	Hello, Thank you for the feedback. You have more than 5000 media files on this site. It looks like a few of them are not synced properly to the secondary languages. Or maybe a compatibility issue with the Code Profiler Pro plugin. I have switched between the themes during the tests. So my suggestion is please make a new staging site. Then try the following steps there and let us know your feedback. 1) Visit WPML>>Settings>>Media Translation 2) Click on the Start button 3) Wait until the process complete 4) Go to WPML>>Support page, click on the Troubleshooting link (blue link in the middle of the page) 5) On the Troubleshooting page, please click on the following options of the Clean up section. Wait for confirmation of processing after each one. - Clear the cache in WPML - Remove ghost entries from the translation tables - Fix element_type collation - Set language information - Fix WPML tables collation - Assign translation status to duplicated content - Fix terms count - Fix post type assignment - Cleanup and optimize string tables -- Thanks! Bigul
January 19, 2024 at 3:20 pm #15205572
prajwalM	Hello, Please close the ticket. We deactivated the wpml media plugin and the website running faster as compared to earlier. We can't wait longer. Thanks for your all support Regards, ATS Team
January 21, 2024 at 3:22 am #15207816
Bigul	Hello, Thank you for the feedback. Please feel free to ping us if you need any further assistance with WPML. We are happy to help always. -- Thanks! Bigul