4 ms·
> The performance difference arises (we believe) because when working from an SQLite database, the open() and close() system calls are invoked only once, wherea
by leni536 2y ago
> The performance difference arises (we believe) because when working from an SQLite database, the open() and close() system calls are invoked only once, whereas open() and close() are invoked once for each blob when using blobs stored in individual files. It appears that the overhead of calling open() and close() is greater than the overhead of using the database
I wonder how io_uring compares.
- 01HNNWZ0MV43FF 2y agoYeah but imagine a Beowulf cluster^H^H io_uring of SQLites
- xyzzy123 2y agoIt seems like nobody has suggested putting SQLite databases inside SQLite blobs yet... you could have SQLite all the way down.
- nilsherzig 2y agohttps://news.ycombinator.com/item?id=41085856 https://news.ycombinator.com/item?id=41085856
- account42 2y agoImagine the peformance we could reach. With enough SQLite layers anything would be possible.
- tantalor 2y agoRecordIO would be a good choice for this use case https://mesos.apache.org/documentation/latest/recordio/ https://mesos.apache.org/documentation/latest/recordio/