Queries and continuous updates of the database (Performance impact) - WPML

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 1 reply, has 2 voices.

Last updated by Prosenjit Barman 1 year, 11 months ago.

Assisted by: Prosenjit Barman.

Author	Posts
February 17, 2023 at 6:44 pm #13059091
marie-joseeP-2	I am trying to: Solve some performance issue with my Database I expected to see: Minimal request to DB for WPML Instead, I got: A lot of queries to update table wplf_options, even when we don't update our admin or website. We don't know if this problem is caused by a conflict between WPML et WPMerge. Because WPMerge save all transactions. debug.log [11-Jan-2023 22:32:54 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT word_count FROM wplf_icl_string_packages WHERE post_id = 9004111222014629 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_TM_Word_Count_Refresh_Hooks->{closure}, WPML_TM_Word_Count_Single_Process->process, WPML_TM_Word_Count_Set_Post->process, WPML_TM_Word_Count_Set_Post->calculate_in_lang, WPML_TM_Word_Calculator_Post_Object->count_words, WPML_TM_Word_Calculator_Post_Object->has_string_packages, WPML_TM_Word_Calculator_Post_Packages->count_words, WPML_TM_Word_Calculator_Post_Packages->get_package_counts, WPML_TM_Word_Count_Records->get_packages_word_counts, WPML_ST_Word_Count_Package_Records->get_word_counts
February 20, 2023 at 5:50 am #13066519
Prosenjit Barman Supporter Languages: English (English ) Timezone: Asia/Dhaka (GMT+06:00)	Hello There, Thanks for reaching out to WPML Support. I will try my best to help you in this matter. As WPML interacts with various components on your website, you may notice several SQL operation by WPML. We have took industry standard approach to organize the queries. But, if you're still having issues with performance of the database, then let's try some possible solutions for the issue you. Please check the following Document first and see if it helps to fix the performance issue: https://wpml.org/faq/how-to-optimize-mysql-queries/ If the issue persists even after that, then please navigate to WPML > Support > Troubleshooting and try performing the following actions: • "Clear the cache in WPML" • "Remove ghost entries from the translation tables" • "Fix element_type collation" • "Set language information" • "Fix post type assignment for translations" • "Recreate ST DB Tables" ❗ Before performing these actions, it is strongly recommended to take a full backup of your site and Database. If it also doesn't work, another possibility is to delete transients from your database. You can use this plugin to do that: https://wordpress.org/plugins/rvg-optimize-database/ I hope these solutions will help to optimize the performance of Database. As you're suspecting a conflict with WPMerge plugin, It is recommended to check by deactivating that plugin also. Please test out these solutions and let me know how it goes. If further assistance require, I will be happy to assist you further. Best Regards, Prosenjit.