Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: