3 ms·
Transactions are a separate orthogonal concern. What executemany can do is prepare the statement once and call it multiple times with different sets of paramet
by masklinn 9y ago
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).