{"id":452,"date":"2005-08-18T16:27:12","date_gmt":"2005-08-18T06:27:12","guid":{"rendered":"http:\/\/www.flamingspork.com\/blog\/?p=452"},"modified":"2005-08-18T16:27:12","modified_gmt":"2005-08-18T06:27:12","slug":"election-results-page-performance","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2005\/08\/18\/election-results-page-performance\/","title":{"rendered":"Election results page performance"},"content":{"rendered":"<p>Did the switch of the election-results page from postgresql to mysql today. It&#8217;s about twice as fast (crappy statistics there, but it&#8217;s an approximation).<\/p>\n<p>This is using InnoDB tables.<\/p>\n<p>With prepared statements we should be able to increase performance even further. I enabled the query log for a load of the page &#8211; we&#8217;re doing about 3,500 queries. Hrrm&#8230;. not so good. But using prepared statements should give us maybe another decent boost (a fair bit IIRC the parser overhead)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Did the switch of the election-results page from postgresql to mysql today. It&#8217;s about twice as fast (crappy statistics there, but it&#8217;s an approximation). This is using InnoDB tables. With prepared statements we should be able to increase performance even &hellip; <a href=\"https:\/\/www.flamingspork.com\/blog\/2005\/08\/18\/election-results-page-performance\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[6,13],"tags":[],"class_list":["post-452","post","type-post","status-publish","format-standard","hentry","category-linux-aus","category-memberdb"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-7i","jetpack-related-posts":[{"id":463,"url":"https:\/\/www.flamingspork.com\/blog\/2005\/09\/04\/memberdb-election-results-performance-on-new-laptop\/","url_meta":{"origin":452,"position":0},"title":"MemberDB election-results performance on new laptop","author":"Stewart Smith","date":"2005-09-04","format":false,"excerpt":"So I picked up my new laptop on friday. It's an ASUS V6V - nice and fast, light, good resolution screen and lots of disk and RAM (it came with 1GB, I've got 2GB). Anyway, the transfer of data from my PowerBook went fine. I waited for xfsdump to dump\u2026","rel":"","context":"In &quot;cool gadgets&quot;","block_context":{"text":"cool gadgets","link":"https:\/\/www.flamingspork.com\/blog\/category\/cool-gadgets\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3801,"url":"https:\/\/www.flamingspork.com\/blog\/2014\/09\/19\/mysql-architecture\/","url_meta":{"origin":452,"position":1},"title":"Some current MySQL Architecture writings","author":"Stewart Smith","date":"2014-09-19","format":false,"excerpt":"So, I've been looking around for a while (and a few times now) for any good resources that cover a bunch of MySQL architecture and technical details aimed towards the technically proficient but not MySQL literate audience. I haven't really found anything. I mean, there's the (huge and very detailed)\u2026","rel":"","context":"In &quot;mysql&quot;","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":973,"url":"https:\/\/www.flamingspork.com\/blog\/2008\/01\/11\/memberdb-speed-improvements\/","url_meta":{"origin":452,"position":2},"title":"MemberDB speed improvements","author":"Stewart Smith","date":"2008-01-11","format":false,"excerpt":"So I finally installed the xdebug PHP extension and started doing some performance analysis of MemberDB using xdebug and kcachegrind. The upshot of which is a number of commits to the bzr tree that dramatically improve performance in several key areas. The answer? Caching. I'm not even talking using memcached\u2026","rel":"","context":"In &quot;linux-aus&quot;","block_context":{"text":"linux-aus","link":"https:\/\/www.flamingspork.com\/blog\/category\/linux-aus\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":342,"url":"https:\/\/www.flamingspork.com\/blog\/2005\/01\/16\/preliminary-election-results\/","url_meta":{"origin":452,"position":3},"title":"Preliminary election results","author":"Stewart Smith","date":"2005-01-16","format":false,"excerpt":"Linux Australia members can log into the membership site and view the preliminary results of the 2005 election.","rel":"","context":"In &quot;linux-aus&quot;","block_context":{"text":"linux-aus","link":"https:\/\/www.flamingspork.com\/blog\/category\/linux-aus\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3765,"url":"https:\/\/www.flamingspork.com\/blog\/2014\/06\/03\/1-million-sql-queries-per-second-mysql-5-7-on-power8\/","url_meta":{"origin":452,"position":4},"title":"1 million SQL Queries Per Second: MySQL 5.7 on POWER8","author":"Stewart Smith","date":"2014-06-03","format":false,"excerpt":"I've previously covered MySQL 5.6 on POWER (with patch), MySQL 5.6 Performance on POWER8 (spoiler: new performance record) and MySQL 5.7 on POWER. Of course, The postings on this site are my own and don\u00e2\u20ac\u2122t necessarily represent IBM\u00e2\u20ac\u2122s positions, strategies or opinions. Also, these numbers should be considered preliminary, but\u2026","rel":"","context":"In &quot;code&quot;","block_context":{"text":"code","link":"https:\/\/www.flamingspork.com\/blog\/category\/code\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1395,"url":"https:\/\/www.flamingspork.com\/blog\/2009\/02\/12\/performance-schema-show-me-the-code\/","url_meta":{"origin":452,"position":5},"title":"Performance Schema: Show me the code","author":"Stewart Smith","date":"2009-02-12","format":false,"excerpt":"For such a long worked on feature, with such potential - I find the resistence to publishing a source tree curious (my comments on the topic have been moderated away but others have asked too). I could go and grep through the commits list searching for things (hint: look for\u2026","rel":"","context":"In &quot;drizzle&quot;","block_context":{"text":"drizzle","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/drizzle-work-et-al\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/452","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/comments?post=452"}],"version-history":[{"count":0,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/452\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=452"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=452"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}