General discussion about the SQLite embedded database. headers Richard Hipp | 20 Sep 03:14 2014 Richard Hipp < drh@... > 2014-09-20 01:14:17 GMT The latest SQLite 3.8.7 alpha version (available on the download page http://www.sqlite.org/download.html ) is 50% faster than the 3.7.17 release from 16 months ago. That is to say, it does 50% more work using the same number of CPU cycles. This performance gain is over and above the query planner improvements that have also been made. We are constantly looking for new ways to run queries and adding those ways into the query planner. For example, in the previous release, we added a new way to evaluate IN operators with non-constant right-hand-sides that was reported on this mailing list to make some queries run 5 times faster. The 50% faster number above is not about better query plans. This is 50% faster at the low-...