News for hackers. Stuff that matters.

A comment on Many small queries are efficient in SQLite. Parent comment

Re:Many small queries are efficient in SQLite by lrem on Tuesday February 16, 2021 @03:11AM (#26151909)
I've recently had my Python script generate about 100GB of data and inserting them into SQLite was _far_ from being the bottleneck.
[ Parent | on HN ]
Re:Many small queries are efficient in SQLite by bhaak on Tuesday February 16, 2021 @10:37AM (#26154846)
I suppose OP was committing too often or even had autocommit on.

Then it wouldn't actually haven been a case of "bulk insert" at all.

[ Parent | on HN ]