News for hackers. Stuff that matters.
Re:Sqlitefs: SQLite as a Filesystem by zoky on Saturday July 27, 2024 @09:04AM (#41086319)
It turns out if you run SQLiteFS on SQLiteFS, performance increases exponentially, and as the number of SQLiteFS layers increases, seek and read times asymptotically approach zero. In other words, this is the world’s first O(0) file system.

At this rate, with only a few performance tweaks, SQLiteFS should be able to retrieve files before you even ask for them.

Re:Sqlitefs: SQLite as a Filesystem by smitty1e on Saturday July 27, 2024 @12:17PM (#41087497)
Less humorously, if one were calculating a few files for compilation, or caching for a service, a SqliteFS using :memory: might be just the thing.
Re:Sqlitefs: SQLite as a Filesystem by earthboundkid on Saturday July 27, 2024 @09:20AM (#41086411)
The problem is that it sends you files before you need them, which clogs up throughput as you try to figure out what the files are supposed to be for. It's more efficient to slow everything back down to NVMe speeds.