Background of the issue:
I am experiencing performance issues after switching my website to a multi-domain structure. The primary domain is surfcamp.it, and I have one WordPress installation serving three different domains for different languages. The server has 1GB RAM, PHP 8.3.22, and Redis caching enabled. Performance was acceptable in development with a subdirectory structure but became severe after switching to a multi-domain production setup. I previously opened a ticket about performance issues, but it was closed due to server issues with WPML. I am following documentation from WPML's website.
Symptoms:
Extremely slow page loads (15+ seconds) with approximately 1,500 database requests per page. The slowest queries are from WPML, specifically sitepress-multilingual-cms. I was also getting 'cURL error 6: Could not resolve host: ate.wpml.org' on certain pages, which seems like a license issue, but this issue seems to be resolved now.
Questions:
What WPML configuration optimizations can improve performance with our multi-domain setup?
Welcome to the WPML support forum. Before passing this thread to my colleague, I would like to share some suggestions and possible solutions for the issues you mentioned.
Are you noticing any specific slow queries related to WPML on the frontend or backend of the site?
Please try the following troubleshooting steps after a full site backup {mandatory} and check if there is any difference in the results.
1) Go to WPML>>Support page, click on the Troubleshooting link (blue link in the middle of the page)
2) 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
3) Visit Settings >> Permalinks, resave the settings
Please try the workaround suggested in the following documentation to resolve the issue: cURL error 6: Could not resolve host: ate.wpml.org.
Thanks for the troubleshooting steps - I have already tried them all but unfortunately the cleanup doesn't help so much.
Yesterday I had the cURL errors but it seems like they were caused by the issues that your servers had the last few days.
There isn't any particularly slow queries from WPML or sitepress_cms but there are many still related with WPML :
- I have 1109 queries only from sitepress_multilingual_cms
- many duplicates too like example : WPML_Term_Query_Filter->get_terms() is ran nearly 10 times
Any other suggestions ? or questions so we can dig deeper ?
Thanks
Languages: English (English )German (Deutsch )French (Français )
Timezone: Europe/Zagreb (GMT+02:00)
Hi,
229 ms for this query might be acceptable for the backend call, given that WPML processes quite a lot of language information under the hood.
Can you please check the performance when:
- only WPML plugins are activated, as it will tell us if there is an interaction issue with other plugin
- theme is set to a WordPress default like Twenty Twenty as it will tell us if there is an interaction issue with your theme
If the issue is still there after these tests, would you be willing to provide me with WordPress credentials so I could investigate the issue directly?
