On Wed, Mar 4, 2020 at 3:20 PM Larry Martell wrote:
>
> I have some Python code that uses pyodbc to talk to a SQL Server database. In
> that code I do an INSERT INTO SELECT * FROM
>
> That query takes around 3 times longer to run when invoked from Python with
> pyodbc than when run wi
I have some Python code that uses pyodbc to talk to a SQL Server database.
In that code I do an INSERT INTO SELECT * FROM
That query takes around 3 times longer to run when invoked from Python with
pyodbc than when run with direct SQL.
On one system we have 1,667 rows and the timings a