henryp-10

Problem:
The client reported that their site was running slow due to WPML database queries, even after installing WP Rocket for performance enhancement. The specific slow query identified was impacting the site's performance by 0.8-3.0 seconds.
Solution:
We identified that the slow query was related to translation jobs in WPML that needed review but were not appearing as pending in the translation management. Initially, attempts to fix this using WPML Troubleshooting options were unsuccessful. We then executed an SQL query to remove over 100,000 old translation status entries from the database, which appeared to resolve the issue with slow queries. The SQL command used was:

DELETE FROM `wp_icl_translation_status` WHERE `status` = 9

If this solution does not resolve your issue, or if it seems outdated or irrelevant to your 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 further assistance is needed, please open a new support ticket at WPML support forum.