Skip to content
Advertisement

Specifying pyODBC options (fast_executemany = True in particular) using SQLAlchemy

I would like to switch on the fast_executemany option for the pyODBC driver while using SQLAlchemy to insert rows to a table. By default it is of and the code runs really slow… Could anyone suggest how to do this?

Edits:

I am using pyODBC 4.0.21 and SQLAlchemy 1.1.13 and a simplified sample of the code I am using are presented below.

JavaScript

Advertisement

Answer

Try this for pyodbc

JavaScript
User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement