python mssql bulk_Python+MySQL - Bulk Insert

There is a smarter way.

The problem with bulk insertions is that by default autocommit is enabled thus causing each insert statement to be saved to stable store before the next insert can initiate.

As the manual page notes:

By default, MySQL runs with autocommit  mode enabled. This means that as soon  as you execute a statement that  updates (modifies) a table, MySQL  stores the update on disk to make it  permanent. To disable autocommit mode,  use the following statement:SET autocommit=0;

After disabling  autocommit mode by setting the  autocommit variable to zero, changes  to transaction-safe tables (such as  those for InnoDB, BDB, or NDBCLUSTER)  are not made permanent immediately.  You must use COMMIT to store your  changes to disk or ROLLBACK to ignore  the changes.

This is a pretty common feature of RDBMs systems which presume that database integrity is paramount. It does make bulk inserts take on the order of 1s per insert instead of 1ms. The alternative of making an overlarge insert statement tries to achieve this single commit at risk of overloading the SQL parser.