News for hackers. Stuff that matters.

A comment on Why SQLite succeeded as a database (2016). Parent comment

Re:Why SQLite succeeded as a database (2016) by felixge on Thursday February 20, 2020 @05:47AM (#22374144)
I love SQLite, but I'd be curious how you were able to saturate an NVMe drive with it. Were you doing the inserts in large batches?

Saturating an NVMe drive requires writing with very large block sizes or very high queue depths.

[ Parent | on HN ]
Re:Why SQLite succeeded as a database (2016) by bob1029 on Thursday February 20, 2020 @09:10AM (#22375141)
Inserting rows with ~500KB blob columns (JSON data) on a single connection w/ WAL enabled & pragma synchronous == NORMAL or OFF.

I will admit that it would be very difficult to saturate a disk that can write on the order of gigabytes per second if you are trying to insert rows that are only a few KB in size (at least without batching these into larger entities or requests).

[ Parent | on HN ]