{"id":9750,"date":"2014-10-06T14:22:37","date_gmt":"2014-10-06T18:22:37","guid":{"rendered":"http:\/\/mjtsai.com\/blog\/?p=9750"},"modified":"2014-10-06T14:22:38","modified_gmt":"2014-10-06T18:22:38","slug":"sqlite-3-8-7-alpha-50-faster-than-3-7-17","status":"publish","type":"post","link":"https:\/\/mjtsai.com\/blog\/2014\/10\/06\/sqlite-3-8-7-alpha-50-faster-than-3-7-17\/","title":{"rendered":"SQLite 3.8.7 Alpha 50% Faster Than 3.7.17"},"content":{"rendered":"<p><a href=\"http:\/\/permalink.gmane.org\/gmane.comp.db.sqlite.general\/90549\">D. Richard Hipp<\/a> (via <a href=\"https:\/\/news.ycombinator.com\/item?id=8385259\">Hacker News<\/a>):<\/p>\n<blockquote cite=\"http:\/\/permalink.gmane.org\/gmane.comp.db.sqlite.general\/90549\"><p>The 50% faster number above is not about better query plans.  This is 50%\nfaster at the low-level grunt work of moving bits on and off disk and\nsearch b-trees.  We have achieved this by incorporating hundreds of\nmicro-optimizations.  Each micro-optimization might improve the performance\nby as little as 0.05%.  If we get one that improves performance by 0.25%,\nthat is considered a huge win.  Each of these optimizations is unmeasurable\non a real-world system (we have to use cachegrind to get repeatable\nrun-times) but if you do enough of them, they add up.<\/p><\/blockquote>\n<p>Mac OS X 10.9.5 includes SQLite 3.7.13.<\/p>","protected":false},"excerpt":{"rendered":"<p>D. Richard Hipp (via Hacker News): The 50% faster number above is not about better query plans. This is 50% faster at the low-level grunt work of moving bits on and off disk and search b-trees. We have achieved this by incorporating hundreds of micro-optimizations. Each micro-optimization might improve the performance by as little as [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"apple_news_api_created_at":"","apple_news_api_id":"","apple_news_api_modified_at":"","apple_news_api_revision":"","apple_news_api_share_url":"","apple_news_coverimage":0,"apple_news_coverimage_caption":"","apple_news_is_hidden":false,"apple_news_is_paid":false,"apple_news_is_preview":false,"apple_news_is_sponsored":false,"apple_news_maturity_rating":"","apple_news_metadata":"\"\"","apple_news_pullquote":"","apple_news_pullquote_position":"","apple_news_slug":"","apple_news_sections":"\"\"","apple_news_suppress_video_url":false,"apple_news_use_image_component":false,"footnotes":""},"categories":[4],"tags":[143,30,74,138,71,425],"class_list":["post-9750","post","type-post","status-publish","format-standard","hentry","category-programming-category","tag-database","tag-mac","tag-opensource","tag-optimization","tag-programming","tag-sqlite"],"apple_news_notices":[],"_links":{"self":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/9750","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/comments?post=9750"}],"version-history":[{"count":1,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/9750\/revisions"}],"predecessor-version":[{"id":9751,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/9750\/revisions\/9751"}],"wp:attachment":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/media?parent=9750"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/categories?post=9750"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/tags?post=9750"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}