Background of the issue:
I am trying to improve the performance of my website when WPML is enabled. When accessing one of the product pages, I noticed a spike in usage. Tracing the process showed the following query: SELECT ... FROM wpml_translations, which is executed dozens of times per second. This causes a significant load on Redis. Disabling the WPML translation plugins speeds up the loading of all pages significantly. Here is the link to a page where the issue can be seen: hidden link.
Symptoms:
There is a performance issue with the website when WPML is enabled, resulting in 127 queries on the database for a simple product, which is more than expected.
Questions:
How can I reduce the number of queries executed by WPML?
What steps can I take to improve website performance with WPML enabled?
Languages: English (English )Spanish (Español )Italian (Italiano )
Timezone: Europe/Madrid (GMT+02:00)
Hi there!
I am getting 404 error on staging site.
Please do the following test:
- change to parent theme and then to a default theme to see the difference
- deactivate plugins 1 by 1 to see the difference
we have created the staging site. We changed the themes but the issue is the same. More than 100 database queries from sitepress and 60 from wpml-string-translation
You can check as well
hidden link
the credentials to login are the same as before for the live site