Updated to version 6.3, the site became very slow due to WPML queries

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 21 replies, has 3 voices.

Last updated by Carlos Rojas 1 year, 3 months ago.

Assisted by: Carlos Rojas.

Author	Posts
August 14, 2023 at 2:38 pm
zmicierZ	After WordPress was automatically updated to version 6.3, the site became very slow: huge server load. Switching between menu tabs in the control panel started taking 40-60 seconds. Query Monitor shows page load time 35-40 seconds. The number of requests to the database is about 8000. About 7000 of them are requests from WPML String Translation. Updating WPML versions to the newest ones did not change the situation. Rolled back on the test site WordPress to version 6.2.2 - the site starts working. When updating to 6.3 - it crashes again. Disabling all other plugins (Woocommerce and Elementor not disabled) practically does not affect the situation.
August 14, 2023 at 3:27 pm
August 14, 2023 at 3:45 pm #14198547
Mateus Getulio Supporter Languages: English (English ) Portuguese (Brazil) (Português ) Timezone: America/Sao_Paulo (GMT-03:00)	Hi there, As we discussed on the chat, please proceed with the investigation as explained here: https://wpml.org/faq/how-to-debug-performance-problems/, and let us know about your results. Looking forward to your reply. Thank you.
August 14, 2023 at 3:59 pm #14198665
zmicierZ	It doesn't fit in pastebin.com, so I'm posting a link to pastes.io: hidden link. You can also see more details in the admin, which I provided access to.
August 16, 2023 at 10:19 am #14208459
Carlos Rojas Supporter Languages: English (English ) Spanish (Español ) Timezone: Europe/Madrid (GMT+01:00)	Hello, My name is Carlos and I will continue working on this ticket I suspect there might be some issues coming from the server-side because the first time I tried to access the site I got an error, but then it worked fine (in the second attempt to log in). I can see the performance issue, but I'm not sure if it's caused by WPML because after deactivating all the WPML plugins the site is still very slow. I'd recommend you to: - Create a full backup of the site - Update all outdated plugins and themes - Flush the cache memory - Deactivate all plugins, including the WPML ones - Activate a default WordPress theme, like Twenty Twenty - If the issue disappeared, start by activating the WPML plugins, then the theme and then the rest of the plugins, one by one, until the issue appears again and you find the culprit Could you tell me the results of the steps described above?
August 16, 2023 at 2:03 pm #14237033
zmicierZ	We were doing all of this before we even approached you. Now we've made a new copy and done it again.
August 17, 2023 at 8:16 am #14243581
Carlos Rojas Supporter Languages: English (English ) Spanish (Español ) Timezone: Europe/Madrid (GMT+01:00)	Hi there, Thank you very much for your message and the screenshots shared I would like to ask for your authorization to create a copy of the site in order to escalate this ticket to our 2nd tier of support. Looking forward to your message.
August 17, 2023 at 9:50 am #14244527
zmicierZ	Yes, of course. What do you want me to do?
August 17, 2023 at 11:03 am #14245307
Carlos Rojas Supporter Languages: English (English ) Spanish (Español ) Timezone: Europe/Madrid (GMT+01:00)	Hi there, I have set your next answer as private. Please share a backup of the site using WP All-In-One Migration plugin o Duplicator. Also, please don't save the media library to save space. Looking forward to your message.
August 17, 2023 at 7:41 pm
August 18, 2023 at 8:19 am #14250643
Carlos Rojas Supporter Languages: English (English ) Spanish (Español ) Timezone: Europe/Madrid (GMT+01:00)	Hi, It is not possible to restore the backup as it has over 6Gb. Please create a new backup and exclude the media library so it will take less space. I have set your next answer private so you can share the new backup.
August 18, 2023 at 12:00 pm
August 18, 2023 at 2:09 pm #14252941
Carlos Rojas Supporter Languages: English (English ) Spanish (Español ) Timezone: Europe/Madrid (GMT+01:00)	Hi there, Thank you for sharing this new backup of the site I have escalated this ticket to our 2nd tier of support where our specialists will take a deeper look at this issue and will try to isolate its cause. In the meantime, I recommend you check this new errata page that might be related to the problem on the site: https://wpml.org/errata/wordpress-6-3-performance-issues-with-string-translation-in-specific-scenarios/ Thank you very much for your patience and understanding!
August 21, 2023 at 7:37 am #14260335
Carlos Rojas Supporter Languages: English (English ) Spanish (Español ) Timezone: Europe/Madrid (GMT+01:00)	Hi there, I need to run some steps on the site but the credentials are not working anymore. I have set your next answer private so you can share the access credentials again in a secure way.
August 21, 2023 at 9:38 am