WPML is creating hundreds of database requests

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.

Tagged: Performance

This topic contains 5 replies, has 3 voices.

Last updated by Subash Chandra Poudel 1 year, 11 months ago.

Assisted by: Subash Chandra Poudel.

Author	Posts
June 19, 2023 at 5:47 pm #13853917
melissaZ	Hello, we updated to the latest version of WPML on March 29, 2023 and have noticed a decrease in load times ever since. After digging deeper it appears that WPML is creating hundreds of database requests to get the page per language (up to 7), then display the correct language, resulting in thousands of taxonomy queries.
June 19, 2023 at 6:30 pm #13854137
Mateus Getulio Supporter Languages: English (English ) Portuguese (Brazil) (Português ) Timezone: America/Sao_Paulo (GMT-03:00)	Hello again, As we discussed on the chat, please check if it is possible to provide us with the website access, or with a package. I'm enabling the private fields for you. Please let us know. Thank you, Mateus.
June 23, 2023 at 2:26 pm #13885593
Subash Chandra Poudel	Hi there, I am Subash and I will help you further here. I tried downloading the backup file but it does not seem to work. The file download is broken every time I try around 1.3 and 2.1 GB. Also the site gives "ERR_EMPTY_RESPONSE" every now and then! Can you please provide a copy of the site again? If you could upload the site copy to a file sharing app like Google Drive or Dropbox and share the link from there instead it could help. More details at: https://wpml.org/faq/provide-supporters-copy-site/ Also, please user my email: subash.cp@onthegosystems.com and IP: 27.34.48.0 if you need it to provide access. I have enabled the private reply for you to share the credentials safely. FURTHERMORE: I will need your permission to install plugins like https://wordpress.org/plugins/query-monitor/ on the site to further troubleshoot the issue. Regards, Subash
June 27, 2023 at 8:33 am #13900393
Subash Chandra Poudel	Thank you for the details. However it looks like my IP have been changed to 27.34.1.58 and I see the message: "You have been blocked" when trying to access the site. Can you please add my new IP to the firewall and let me know?
June 28, 2023 at 4:54 pm #13912409
melissaZ	Hi Subash, your IP has been updated. Let me know if you run into any more issues.
June 29, 2023 at 3:43 pm #13919421
Subash Chandra Poudel	Thank you for the details. I am now able to login. I momentarily installed the plugin Query Monitor ( https://wordpress.org/plugins/query-monitor/ ) on your site to check the issue further. I checked the Homepage and I see the slow Database queries are generated by other plugins and the total impact of WPML queries on the site load speed is only 0.1 seconds as shown on the screenshot. I recommend you to troubleshoot the issue further with the Query Monitor result and respective plugin's support doing slow database queries . So WPML does not seem to cause any site speed or database impact on the site. Furthermore, we recently released WPML 4.6.4 with some performance improvement so I recommend you update WPML plugins to latest versions and see if it further helps with the issue.