3 ms·
No mention of how it performs when you need random access (seek) into files. Perhaps it underperforms the file system at that?
by dmurray 2y ago
No mention of how it performs when you need random access (seek) into files. Perhaps it underperforms the file system at that?
- bhawks 2y agoProbably 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.
- simonw 2y agoSQLite does have low-level C APIs for that: https://www.sqlite.org/c3ref/blob_open.html https://www.sqlite.org/c3ref/blob_open.html https://www.sqlite.org/c3ref/blob_read.html https://www.sqlite.org/c3ref/blob_read.html I've not seen performance numbers for those. Could make for an interesting micro-benchmark.