Roger Dant wrote:
Since INSERT INTO is the only way I know of to populate a table, I'm assuming that I'll have to find a way to optimize these calls. Do you have any tips for optimizing mass INSERTs in Sqlite?
Try doing all the INSERTs in a single transaction.
