In my case, 3M rows having 5 columns were inserted in 8 mins when I used pandas to_sql
function parameters as chunksize=5000 and method=’multi’. This was a huge improvement as inserting 3M rows using python into the database was becoming very hard for me.