News for hackers. Stuff that matters.
Re:SQLite is 35% Faster Than The Filesystem (2017) by vincent-toups on Tuesday July 20, 2021 @02:42PM (#27897538)
I'd be shocked if this weren't the case.
Re:SQLite is 35% Faster Than The Filesystem (2017) by bsaul on Tuesday July 20, 2021 @03:26PM (#27898089)
I guess you must be a low-level developer then, because to application developer it would seem that sqlite write speed is actually bound by the file system performance (which it depends on).
Re:SQLite is 35% Faster Than The Filesystem (2017) by tantalor on Tuesday July 20, 2021 @03:30PM (#27898143)
The title is a joke, right? It's not actually "faster than the filesystem" unless it's not using the filesystem; it's faster than something else that also uses the filesystem because they use different system calls (context switching).
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.

Re:SQLite is 35% Faster Than The Filesystem (2017) by harikb on Tuesday July 20, 2021 @03:30PM (#27898142)
The correct comparison is “SQLite index” is faster compared to “file system inode index”