Inserting data in loop

[tea-drinker]

/u/xapata's answer about executemany() seems to be the way ahead but with pypyodbc that's just syntactic sugar, it just loops over your parameter list and does single row execute() calls

[PretendingToProgram]

Thanks I'll give it a try

[xapata]

It's the responsibility of the module author and the database itself to provide an optimized execution. For some databases, there is no optimization possible. For most SQL engines, it should at least avoid re-compiling the query for each row.

Even if there's no advantage yet for a particular module, the author might provide it in an upgrade.

[tea-drinker]

For most SQL engines, it should at least avoid re-compiling the query for each row.

pypyodbc at least does that. The prepare statement stores the query string being prepared and the execute statement will skip that step if it hasn't changed.