Enviroment:
When I use cursor.executemany()
with cursor.fast_executemany = False
to insert data to MSSQL table it works fine, but too slow (about 1h to write ~100000 rows).
When I use cursor.executemany()
with cursor.fast_executemany = True
it works fast (about 1m to write the ~100000 rows) and write exactly the same data with the first case but the process finishes with exit code -1073741571 (0xC00000FD) and error <built-in method executemany of pyodbc.Cursor object at 0x000001DE578AA210> returned a result with an error set
occurs.
The data for an insert has a structure:
How can I get the result without having exception?
User contributions licensed under CC BY-SA 3.0