Hacker News new | ask | show | jobs
by trevyn 4081 days ago
Actually, all you needed to do was wrap that batch update in a transaction; by default, SQLite autocommits and writes to disk after each update/insert, which is a bit slow.