News for hackers. Stuff that matters.
Re:Getting the Most Out of Sqlite3 with Python by masklinn on Sunday October 22, 2017 @01:42PM (#15527934)
Transactions are a separate orthogonal concern.

What executemany can do is prepare the statement once and call it multiple times with different sets of parameters, whereas execute may be preparing the statement every time it is called (possibly hoping that the database system has a statements cache) or not preparing them at all (and the DBMS only does simple query planning).

There are no comments on this comment yet.