{"id":7623,"date":"2011-05-27T09:45:54","date_gmt":"2011-05-27T09:45:54","guid":{"rendered":"http:\/\/wpml.org\/?post_type=faq&p=7623"},"modified":"2023-09-06T08:35:34","modified_gmt":"2023-09-06T08:35:34","slug":"how-to-optimize-mysql-queries","status":"publish","type":"faq","link":"https:\/\/wpml.org\/it\/faq\/how-to-optimize-mysql-queries\/","title":{"rendered":"How can I optimize MySQL queries for translated pages?"},"content":{"rendered":"

You can optimize MySQL queries by first checking where problems are coming from. When you see an unexpectedly large number of queries, check your String Translation Tracking <\/strong>and Auto ID Adjust <\/strong>as potential sources.<\/p>\n

To learn more about identifying performance issues using the Debug Objects <\/strong>plugin, visit our FAQ on debugging performance problems<\/a>.<\/p>\n

How to optimize String Translation Tracking?<\/h2>\n

String Translation Tracking triggers SQL queries when you’re logged in as Admin. To enhance performance, navigate to WPML <\/strong>\u2192 String Translation <\/strong>and make sure that Track where strings appear on the site <\/strong>is not checked. <\/p>\n

How to optimize Auto ID Adjust?<\/h2>\n

If Adjust IDs for multilingual functionality<\/strong> is selected, WPML will perform SQL queries whenever the theme tries to load items with specific IDs.<\/p>\n

You can disable this option in in WPML <\/strong>\u2192 Languages <\/strong>\u2192 Make themes work multilingual <\/strong>and use icl_object_id<\/strong> and other functions from WPML’s API <\/a>instead, to turn your theme multilingual.<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

When you see an unexpectedly large number of queries you can improve performance of translated pages by turning off the String Translation Tracking and Auto ID Adjust features.<\/p>\n","protected":false},"author":2,"featured_media":0,"menu_order":90,"template":"","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_uag_custom_page_level_css":"","ep_exclude_from_search":false,"footnotes":""},"faq-category":[26137],"class_list":["post-7623","faq","type-faq","status-publish","hentry","faq-category-how-to"],"spectra_custom_meta":{"_edit_last":["578773"],"_edit_lock":["1693989607:578773"],"_icl_translator_note":[""],"_alp_processed":["1693989335"],"_views_template":["0"],"_subscription_coupon_product_id":["0"],"inline_featured_image":["0"],"_wpml_word_count":["205"],"_oembed_b9ed4048f72ad6c7db9e194b36b2ddd7":["