I run the cleaning plugin procedure
After 3 times of cleaning (50+50+30 = 130 ID's)
the final result is: 14566 rows deleted from icl_translation_status table.
Unfortunately the site is underperforming. Products / Categories load in 3-4 seconds. If WPML is off - 1-1,5 second.
I read all post you have (more than 100) with all the suggestions and nothing help.
We are running on VDS machine and is well configured.
NGINX cache also not helping. As Redis cache gain 1 second in general.
What do you need to help me?
Please notice this problem will be better if a 2nd level can handle this because all "standard" and routine procedure are made. Most probably should be seen the MySql tables and the index in each table.
If you need further help with this, please share the access details to your site with me. I'm enabling a private message for the following reply. After that, I'll move your ticket to the 2nd tier support team.
- Please backup the site files and database before providing us access.
- If you have a staging site where the problem can be reproduced, it is better to share access to the staging site.
Thank you for providing the direct login link. I want to forward this to our second-tier support team so they can enable/disable plugins and run some SQL queries. To ensure that our tests do not interfere with your live site, I'd request you create a staging site and provide us with the login credentials.
The website's backup files you sent are too large. Could you use the All-in-One WP Migration plugin (https://wordpress.org/plugins/all-in-one-wp-migration/) to create a backup and then send it? You can upload the backup file to Google Drive and then send me the link to download it.
To help you exclude spam comments, post revisions, and media files, here is a screen recording that will guide you through the process: hidden link.