Background of the issue:
My website has been experiencing performance problems for some time. In the server statistics, I can see an overload in terms of memory used, but especially CPU processes. After a lot of searching, I noticed that a big problem is your plug-in. This is the number of database queries and loading time (by Query Monitor) before enabling the main WPML plugin (home page and post): hidden link. This is after enabling (home page and post): hidden link. I can give you access to a test server on which you can see it perfectly. Link to a page where the issue can be seen: hidden link
Symptoms:
The number of database queries increases significantly when WPML is enabled, leading to server load issues with memory and CPU.
Questions:
Is it normal that the number of database queries increases so much when WPML is enabled?
Please, can you help me?
The foundation of the server (PHP version, MYSQL, WP Memory Limit, etc) looks OK. I'd only suggest that you increase the WP MEMORY LIMIT to 500M.
Please review the following suggestions so we can start investigating this behavior.
#1
WPML Media -- deactivating it could help with performance unless you want to use different images across posts, pages, and post types in different languages.
Go to WPML -> Settings -> Review the settings for post types, taxonomies, custom fields, etc. and verify that they are not set to "display as translated" (Fallback mode)
#3
Go to WPML->Support->Troubleshooting-> and run
"Cleanup and optimize string tables"
"Clear invalid strings" options.
"Remove ghost entries from WPML tables"
Multilingual plugins require additional resources to function effectively as they manage connections between various elements to make them available for translation.
Hi,
I followed these steps, although define('ICL_DISABLE_CACHE', true) didn't need to remove it because I didn't have it in the wp-config.php file.
Nevertheless, it didn't change anything.
The number of queries is still huge.
Why do you make more than 1,000 queries on the site in the native language when you don't need to do anything, or more than 100 in the admin panel where nothing is translated and there is nothing to translate?
To debug this issue further, I would need to check your site settings once, for this I would need temporary access (wp-admin and ftp) to your site.
So could you please provide me with those details, you will find the needed fields for this below the comment area when you log in to leave your next reply. hidden link
