SQLite Forum

Fast way to insert rows in SQLite
What is the schema of the table you are inserting into?  If you are able
to omit UNIQUE constraints and PRIMARY KEYs (other than INTEGER PRIMARY KEY),
and use "CREATE UNIQUE INDEX" statements that happen *after* the insert in
place of UNIQUE constraints, that will probably work faster.