The best way to effectively do exec many?

[thedmdim]

Hi! Could you advice me the best way to INSERT multiple rows?

1. I could firstly compose INSERT INTO table (col1, col2) VALUES (?, ?), (?, ?), (?, ?) ... and so many (?, ?) as I have rows to write. Then Execute
2. Either I could do sqlitex.Execute(conn, "INSERT INTO table (col1, col2) VALUES (?, ?);", ...) in a loop, for all rows I need to persist

( I use sqlitex.Open())