This thread is resolved. Here is a description of the problem and solution.
Problem:
The client is experiencing an issue where WPML String Translation is running too many slow queries, as reported by their hosting provider.
Solution:
If you're encountering similar issues, we recommend the following steps:
1. Create a backup of your website, or ideally, test these changes on a staging version to avoid disrupting your live site.
2. Navigate to WordPress Dashboard > WPML > Settings and ensure you select the first option for custom post types, especially for 'products' which currently might be using a less optimal setting.
3. Go to WordPress Dashboard > WPML > Support > Troubleshooting and perform the following actions:
- Clear the cache in WPML
- Remove ghost entries from the translation tables
- Cleanup and optimize string tables
- Click on "Clear invalid strings" to delete unused or invalid strings.
These steps should help reduce the number of slow queries generated by WPML String Translation. If this solution does not apply to your situation, or if it seems outdated, 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 issues persist, please open a new support ticket.
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.
This topic contains 4 replies, has 2 voices.
Last updated by 4 months ago.
Assisted by: Christopher Amirian.