4 ms·
Does SQLite do direct disk I/o or something? I’m open to being convinced otherwise, but I would expect that inserts/s would vary a bunch by filesystem. But I
by electric_mayhem 4y ago
Does SQLite do direct disk I/o or something?
I’m open to being convinced otherwise, but I would expect that inserts/s would vary a bunch by filesystem.
But I do agree that local nvme with any file system is absurdly better than what you’re likely to find in typical cloud envs.
- alberth 4y ago> Many programs use fopen(), fread(), and fwrite() to create and manage files of data in home-grown formats. SQLite works particularly well as a replacement for these ad hoc data files. Contrary to intuition, SQLite can be faster than the filesystem for reading and writing content to disk. https://www.sqlite.org/whentouse.html https://www.sqlite.org/whentouse.html
- dundarious 4y agoThat quotation is about a SQLite file db being a better choice than multiple ad-hoc binary files. It’s not saying whether SQLite uses direct IO.