Monday, October 6, 2014 [Tweets] [Favorites]

SQLite 3.8.7 Alpha 50% Faster Than 3.7.17

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 0.05%. If we get one that improves performance by 0.25%, that is considered a huge win. Each of these optimizations is unmeasurable on a real-world system (we have to use cachegrind to get repeatable run-times) but if you do enough of them, they add up.

Mac OS X 10.9.5 includes SQLite 3.7.13.

1 Comment

Mac OS X 10.10 RC1 comes with 3.8.5

Stay up-to-date by subscribing to the Comments RSS Feed for this post.

Leave a Comment