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 … Continue reading SQLite 3.8.7 Alpha 50% Faster Than 3.7.17