Re:SQLite is 35% Faster Than The Filesystem (2017)
by naikrovek on Tuesday July 20, 2021 @03:49PM
(#27898387)
you can be faster than the filesystem, while using the filesystem, if you emulate something the filesystem does poorly in a more performant way.
That's what's happening here. storing files in SQLite removes any per-file overhead in the filesystem. The filesystem now only has one file to deal with, instead of however many are stored inside the SQLite database.
This is a very real phenomenon, and definitely not a joke.
That's what's happening here. storing files in SQLite removes any per-file overhead in the filesystem. The filesystem now only has one file to deal with, instead of however many are stored inside the SQLite database.
This is a very real phenomenon, and definitely not a joke.