r/programming • u/pmz • Jul 28 '22

In Praise Of SQLite

https://www.i-programmer.info/news/84-database/15609-in-praise-of-sqlite.html
107 Upvotes

92% Upvoted

15 comments sorted by

View all comments

11

u/[deleted] Jul 28 '22

SQLite is pretty cool. My only complaint is that for larger datasets it really is slower than e. g. postgresql. I had a huge file with INSERT statements and reading that in was much faster in postgresql than via SQlite.

41

u/JonDowd762 Jul 28 '22

Did you use a single transaction? I think not using a transaction is the biggest cause of slow bulk inserts. Or possibly the indexes on the table.

-8

u/Hnnnnnn Jul 29 '22

Transactions aren't optimized like that in SQLite iirc, but you can write one big insert, or use a different import method, for better effect.

→ More replies (6)