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
Yes, you can. This is a stag environment so you can turn plugins on and off.
I have been disabling plugins and the problem (more than 1000 queries to the database) appears when WPML plugins are enabled. I didn't test it with the template because nothing has changed in it, and there was no such problem before.
I conducted the following tests, and here are the results:
- WPML plugins enabled with the default theme & WooCommerce: 117 queries
- WPML enabled with the Goodlife theme & WooCommerce: 979 queries
- Goodlife theme enabled with WooCommerce, WPML disabled: 534 queries
Based on these tests, it appears that the Goodlife theme significantly increases the number of queries. When WPML is also activated, the query count rises further. I tried searching for the theme’s official website but couldn't find it. Has the theme been discontinued?
Please note that these tests were conducted using the Query Monitor plugin, which itself impacts performance. Therefore, the actual query count might be slightly lower if the plugin is disabled.
Could you verify my findings on your end and let me know if you observe similar results?
However, before that ( while WPML has also been running with me for a long time) there were no such problems, so I assume it is a problem with WPML and not with the theme. The same goes for woo. That also worked long before WPML along with this theme and there were no problems. WPML fully supports Woocommerce.
Why such an increase in queries here even on a site where there is no need to translate any elements at all?
Yes, we fully support WooCommerce, and I don’t see any issues related to the GoodLife theme being disabled.
The WPML plugin works by controlling how translations are displayed on the front end. If a plugin makes multiple calls (e.g., 10 times), WPML needs to filter those calls to ensure the correct language information is displayed. As a result, the number of queries may increase, which is completely normal.
