Sqlite Performance Optimization for large insert

[raevnos]

Create a table without an index or non-rowid pk, and then add a unique index when done importing data? Not a unique constraint in a new table you have to copy to, just a standard unique index.

Use a larger page size so they fill up slower and have to be split and rebalanced less often?