How to Make Inserts Into SQL Server 100x faster with Pyodbc

How I fixed an issue related to “fast_executemany” when loading data to SQL Server

Photo by Nextvoyage from Pexels

I’ve been recently trying to load large datasets to a SQL Server database with Python. Usually, to speed up the inserts with pyodbc, I tend to use the feature cursor.fast_executemany = True which significantly speeds up the…