https://voidstar.tech/sqlite_insert_speed/
Interesting post on how to speed up batch inserts with SQLite.