{"id":595875,"date":"2015-04-08T15:01:37","date_gmt":"2015-04-08T15:01:37","guid":{"rendered":"https:\/\/wpml.org\/?p=595875"},"modified":"2015-04-08T15:01:37","modified_gmt":"2015-04-08T15:01:37","slug":"wpml-3-2-performance-improvements","status":"publish","type":"post","link":"https:\/\/wpml.org\/pt-br\/announcements\/2015\/04\/wpml-3-2-performance-improvements\/","title":{"rendered":"WPML 3.2 Performance Improvements"},"content":{"rendered":"<p><strong>WPML 3.2 includes a few major updates and performance improvements. We are seeing SQL queries reduced by up to 75% and are looking for more test cases, to tune the performance the best we can.<\/strong><\/p>\n<p>Part of our work on WPML includes optimization for SQL queries. When you run a site on your localhost, the number of queries is less critical. However, production sites that have a lot of traffic and may have an external SQL server, will benefit a lot from reduced queries.<\/p>\n<p>We use three test sites for our optimizations. These include a tiny site, a medium site and a huge site. Each helps with different optimizations. The tiny site represents a typical &#8216;brochure&#8217; website with several pages. The huge site represents a busy e-commerce site with many posts (products). The &#8216;medium&#8217; site is somewhere in the middle. In our journey, we find different optimizations that are more significant for each of these configurations.<\/p>\n<p>So far, our testing shows the following numbers, when comparing WPML 3.2 to 3.1.9.4:<\/p>\n<ul>\n<li>Home page in default language: about 20% fewer SQL queries.<\/li>\n<li>Home page in another language: 20 to 75% fewer SQL queries.<\/li>\n<li>Single page (about page) in default language: about 15% fewer SQL queries.<\/li>\n<li>Single page (about page) in another language: 20 to 80% fewer SQL queries.<\/li>\n<li>WP Dashboard: about 15% fewer queries.<\/li>\n<\/ul>\n<p>Of course these figures depend on the complexity of the site.<\/p>\n<p>Does this reduction in the number of queries also implies faster execution time? Generally yes, but it really depends. If you have a monster CPU and tiny database, your MySQL server works from RAM and you can hardly feel normal queries. If you are on a typical web server, with a big database and a lot of traffic, you&#8217;ll see these fewer queries directly translate into less CPU load.<\/p>\n<h2>Download WPML 3.2 Beta<\/h2>\n<p>The current WPML 3.2 beta is available for Multilingual CMS account holders. Log in to your <a href=\"https:\/\/wpml.org\/account\/\">WPML account<\/a> and click on Downloads. Scroll to the bottom and you will see &#8216;CMS Beta Package&#8217;. Download it and unzip. You will receive ZIP files of all of WPML&#8217;s components in the beta version.<\/p>\n<p>Please keep in mind that this code is not yet ready for production sites. We would love it if you can give WPML 3.2 beta a spin on a dev site, but don&#8217;t use it on production sites yet.<\/p>\n<p>WPML 3.2 is now in QA and we are handling corner cases. As soon as it&#8217;s ready, you&#8217;ll receive it directly to your WordPress admin.<\/p>\n<h2>We Want to Test WPML&#8217;s Performance on Your Site<\/h2>\n<p>We want to make sure that these improvements work on a large variety of sites. <\/p>\n<p>We&#8217;re looking for small to medium sites to do comparison tests on. We&#8217;ll test with 3.1.9.4 and 3.2 and make sure that these speed improvements work on all sites.<\/p>\n<p><strong>If you can help, we need complete <a href=\"https:\/\/wordpress.org\/plugins\/duplicator\/\">Duplicator<\/a> dumps of your site so we can test these sites locally. Please leave your comments and we&#8217;ll get back to you privately.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>WPML 3.2 includes a few major updates and performance improvements. We are seeing SQL queries reduced by up to 75% and are looking for more test cases, to tune the performance the best we can. Part of our work on WPML includes optimization for SQL queries. When you run a site on your localhost, the [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","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":""},"categories":[3],"tags":[],"class_list":["post-595875","post","type-post","status-publish","format-standard","hentry","category-announcements"],"spectra_custom_meta":{"_edit_lock":["1428505303:2"],"_edit_last":["2"],"_alp_processed":["1428505298"],"_views_template":["0"],"_icl_translator_note":[""],"ratings_users":["0"],"ratings_score":["0"],"ratings_average":["0"],"_wpml_media_featured":["1"],"_wpml_media_duplicate":["0"],"_oembed_0a9b7c0e350cccf75658aa2dcf88ed85":["<iframe title=\"How to migrate from a custom database into WordPress\" width=\"700\" height=\"394\" src=\"https:\/\/www.youtube.com\/embed\/2PIChT5T0oQ?feature=oembed&enablejsapi=1&origin=https:\/\/wpml.org\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe>"],"_oembed_time_0a9b7c0e350cccf75658aa2dcf88ed85":["1695979451"],"_oembed_9596c0d9095e7ce9cc90624324ef4422":["<iframe title=\"Duplicator For WordPress Quick Overview\" width=\"700\" height=\"394\" src=\"https:\/\/www.youtube.com\/embed\/yZ7pHmR9JC8?feature=oembed&enablejsapi=1&origin=https:\/\/wpml.org\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe>"],"_oembed_time_9596c0d9095e7ce9cc90624324ef4422":["1695979452"],"_oembed_12570cf8030926800bac0f1584e1e153":["<iframe title=\"How to use the backup wizard in cpanel\" width=\"700\" height=\"394\" src=\"https:\/\/www.youtube.com\/embed\/eS-tCkc-gm0?feature=oembed&enablejsapi=1&origin=https:\/\/wpml.org\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe>"],"_oembed_time_12570cf8030926800bac0f1584e1e153":["1695979452"],"_oembed_1c0ef2e069ab1e666be8a1bac83a42ee":["{{unknown}}"],"_oembed_e9018e6807d31b4505b7ad464275fdce":["<iframe title=\"How to copy multiple accounts from another server to your WHM server using SSH\" width=\"525\" height=\"394\" src=\"https:\/\/www.youtube.com\/embed\/C6ro9h0qowU?feature=oembed&enablejsapi=1&origin=https:\/\/wpml.org\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe>"],"_oembed_time_e9018e6807d31b4505b7ad464275fdce":["1695979452"],"_oembed_9052213bd50132682bbabb79e50bace9":["<iframe title=\"How to use FTP to upload files to WordPress for Beginners\" width=\"700\" height=\"394\" src=\"https:\/\/www.youtube.com\/embed\/_nDQz1JQfYA?feature=oembed&enablejsapi=1&origin=https:\/\/wpml.org\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe>"],"_oembed_time_9052213bd50132682bbabb79e50bace9":["1695979452"],"_oembed_cfcc8d32f359dd000173b240cccb4392":["{{unknown}}"],"_oembed_d812396ab00eaf7ff0dfe458721807c2":["<iframe title=\"Manual update to WPML 3.2\" width=\"525\" height=\"394\" src=\"https:\/\/www.youtube.com\/embed\/4W2S7_pKOeI?feature=oembed&enablejsapi=1&origin=https:\/\/wpml.org\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>"],"_oembed_time_d812396ab00eaf7ff0dfe458721807c2":["1727180824"],"_wpml_word_count":["465"],"_uag_css_file_name":["uag-css-595875.css"],"_uag_page_assets":["a:9:{s:3:\"css\";s:260:\".uag-blocks-common-selector{z-index:var(--z-index-desktop) !important}@media(max-width: 976px){.uag-blocks-common-selector{z-index:var(--z-index-tablet) !important}}@media(max-width: 767px){.uag-blocks-common-selector{z-index:var(--z-index-mobile) !important}}\";s:2:\"js\";s:0:\"\";s:18:\"current_block_list\";a:1:{i:0;s:14:\"core\/shortcode\";}s:8:\"uag_flag\";b:0;s:11:\"uag_version\";s:10:\"1778243285\";s:6:\"gfonts\";a:0:{}s:10:\"gfonts_url\";s:0:\"\";s:12:\"gfonts_files\";a:0:{}s:14:\"uag_faq_layout\";b:0;}"]},"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"gform-image-choice-sm":false,"gform-image-choice-md":false,"gform-image-choice-lg":false,"woocommerce_thumbnail":false,"woocommerce_single":false,"woocommerce_gallery_thumbnail":false},"uagb_author_info":{"display_name":"Amir","author_link":"https:\/\/wpml.org\/pt-br\/author\/amir\/"},"uagb_comment_info":0,"uagb_excerpt":"WPML 3.2 includes a few major updates and performance improvements. We are seeing SQL queries reduced by up to 75% and are looking for more test cases, to tune the performance the best we can. Part of our work on WPML includes optimization for SQL queries. When you run a site on your localhost, the&hellip;","_links":{"self":[{"href":"https:\/\/wpml.org\/pt-br\/wp-json\/wp\/v2\/posts\/595875","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wpml.org\/pt-br\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wpml.org\/pt-br\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wpml.org\/pt-br\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/wpml.org\/pt-br\/wp-json\/wp\/v2\/comments?post=595875"}],"version-history":[{"count":3,"href":"https:\/\/wpml.org\/pt-br\/wp-json\/wp\/v2\/posts\/595875\/revisions"}],"predecessor-version":[{"id":595912,"href":"https:\/\/wpml.org\/pt-br\/wp-json\/wp\/v2\/posts\/595875\/revisions\/595912"}],"wp:attachment":[{"href":"https:\/\/wpml.org\/pt-br\/wp-json\/wp\/v2\/media?parent=595875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wpml.org\/pt-br\/wp-json\/wp\/v2\/categories?post=595875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wpml.org\/pt-br\/wp-json\/wp\/v2\/tags?post=595875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}