SQLite Just Got A Big Speed Boost: Now 2x As Fast As SQLite 3.8.0

Written by Michael Larabel in Free Software on 30 July 2015 at 10:32 AM EDT. 9 Comments
SQLite was released yesterday and while it may not sound exciting from the version number, there are some measurable performance improvements with this popular embedded database update.

The SQLite release notes mention this change, which got us performance freaks excited, "micro-optimizations result in 22.3% more work for the same number of CPU cycles relative to the previous release. SQLite now runs twice as fast as version 3.8.0 and three times as fast as version 3.3.9. (Measured using cachegrind on the speedtest1.c workload on Ubuntu 14.04 x64 with gcc 4.8.2 and -Os. Your performance may vary.)"

While that change seemed most exciting, the new SQLite update also has experimental support for the RBU and FTS5 extensions, improved fuzz-testing of database files, enhanced the page cache, and various other fixes / improvements.
Related News
About The Author
Michael Larabel

Michael Larabel is the principal author of Phoronix.com and founded the site in 2004 with a focus on enriching the Linux hardware experience. Michael has written more than 20,000 articles covering the state of Linux hardware support, Linux performance, graphics drivers, and other topics. Michael is also the lead developer of the Phoronix Test Suite, Phoromatic, and OpenBenchmarking.org automated benchmarking software. He can be followed via Twitter, LinkedIn, or contacted via MichaelLarabel.com.

Popular News This Week