Re: pyodbc slowness

2020-03-04 Thread Larry Martell
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

pyodbc slowness

2020-03-04 Thread Larry Martell
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