Re:SQLite small blob storage: 35% Faster Than the Filesystem
by ori_b on Tuesday June 13, 2017 @11:56PM
(#14550565)
A big part of it is because they're repeatedly walking the same path while reading and writing it. I got a 20% performance improvement on FreeBSD+ZFS with this change, which merely opens an fd, and uses that to stat and write, cutting the number of path traversals in half:
https://eigenstate.org/paste/d41e3b69d258e3b52f7cee7a9921f02...