{"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\/it\/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,"ep_exclude_from_search":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-595875","post","type-post","status-publish","format-standard","hentry","category-announcements"],"_links":{"self":[{"href":"https:\/\/wpml.org\/it\/wp-json\/wp\/v2\/posts\/595875","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wpml.org\/it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wpml.org\/it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wpml.org\/it\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/wpml.org\/it\/wp-json\/wp\/v2\/comments?post=595875"}],"version-history":[{"count":3,"href":"https:\/\/wpml.org\/it\/wp-json\/wp\/v2\/posts\/595875\/revisions"}],"predecessor-version":[{"id":595912,"href":"https:\/\/wpml.org\/it\/wp-json\/wp\/v2\/posts\/595875\/revisions\/595912"}],"wp:attachment":[{"href":"https:\/\/wpml.org\/it\/wp-json\/wp\/v2\/media?parent=595875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wpml.org\/it\/wp-json\/wp\/v2\/categories?post=595875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wpml.org\/it\/wp-json\/wp\/v2\/tags?post=595875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}