SQLite Just Got A Big Speed Boost: Now 2x As Fast As SQLite 3.8.0
SQLite 3.8.11.1 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 3.8.11.1 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 3.8.11.1 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.
The SQLite 3.8.11.1 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 3.8.11.1 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.
9 Comments