News for hackers. Stuff that matters.
Re:Sqlitefs: SQLite as a Filesystem by punnerud on Saturday July 27, 2024 @08:28AM (#41086150)
If SQLite is faster than a normal file system, how fast is SQLite running on “SQLite as a filesystem”?
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.
Re:Sqlitefs: SQLite as a Filesystem by bilekas on Saturday July 27, 2024 @09:12AM (#41086361)
Jokes aside, if I understand correctly it's still assumed the performance increase from the sqlLite is down to the reduced number of OPEN and CLOSE calls. So if that's the case, then it will be as slow as however many sqllites you're running? Meaning it should in theory lose performance?!
Re:Sqlitefs: SQLite as a Filesystem by lupire on Saturday July 27, 2024 @09:22AM (#41086427)
Obviously adding redundant layers will reduce performance.