News for hackers. Stuff that matters.
Re:DBOS: A database-oriented operating system by esjeon on Sunday September 04, 2022 @01:52AM (#32710231)
The page says:

> SQLite reads and writes small blobs 35% faster¹ than the same blobs can be read from or written to individual files on disk using fread() or fwrite().

This is likely because of the hierarchical nature of the filesystem. The filesystem path lookup can be slower than DB index lookup (depends on actual implementation). I haven't tried this, but something like getdents(2) would improve the performance of the test C code here, as one can skip full path lookup.

There are no comments on this comment yet.