I am \insertingdata into a microsoft sql server using pyodbc. I am finding it is taking an incredible amount of time with even as little at a couple thousand rows (I honestly . I would really appreciate any faster solutions.
Asked
Active
Viewed 24 times
0
-
Avoid posting images of your code, just write it – Sozy Jul 02 '21 at 10:42
-
Are you able to verify how long such operation would take when run directly from mssql console? Maybe that's not because of pyodbc, but maybe there is something wrong with sql structure (too many indexes for example)? – Adam Tokarski Jul 02 '21 at 11:22
-
And yes, it would be easier to say anything more if you had post with actual code, not images. And with the whole code, not only a cut part of it. – Adam Tokarski Jul 02 '21 at 11:23