to_sql is very slow for sql server with sqlalchemy

[anjsudh]

df.to_sql is very slow, and takes hours, when connecting to sql server using sql alchemy connection
https://github.com/mkleehammer/pyodbc/wiki/Features-beyond-the-DB-API#fast_executemany

Performance is much faster after using fast_executemany

@event.listens_for(engine_local, 'before_cursor_execute')
def receive_before_cursor_execute(conn, cursor, statement, params, context, executemany):
    if executemany:
        cursor.fast_executemany = True

Can enable fast_executemany in to_sql implementation for SQL Server

[TomAugspurger]

Duplicate of #8953 I believe. #21401 will fix this.

[tauqeerhasan]

please share the full code to export dataframe to database..
i have 10300000 rows and df.to_sql is working very very slow.. i need a fast performance code..

[sepjc96]

@tauqeerhasan have you figured out how to enhance the speed?