Correct. Drop indexes for inserts and recreate after bulk inserts. Also, another hint: process all inserts in the bulk in a single transaction. I was amazed at

Correct. Drop indexes for inserts and recreate after bulk inserts. Also, another hint: process all inserts in the bulk in a single transaction. I was amazed at the speed that SQLite ingests data! Speed demon! (Don’t forget PRAGMA synchronous OFF too)