Comment by dmurray
2 years ago
No mention of how it performs when you need random access (seek) into files. Perhaps it underperforms the file system at that?
2 years ago
No mention of how it performs when you need random access (seek) into files. Perhaps it underperforms the file system at that?
Probably because you wouldn't seek into a database row?
I guess querying by PK has some similarities but it is not as unstructured and random as a seek.
Also side effects such as sparse files do not mean much from a database interface standpoint.
SQLite does have low-level C APIs for that:
https://www.sqlite.org/c3ref/blob_open.html
https://www.sqlite.org/c3ref/blob_read.html
I've not seen performance numbers for those. Could make for an interesting micro-benchmark.