SQLite Forum

Faster way to insert into WITHOUT ROWID table?
Login
How are you executing the SQL that does the inserting?  Are you preparing
a new SQL statement for each row?  Or do you prepare a single INSERT statement
using parameters, then bind data to the parameters and rerun that one statement
for each row?