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

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.