mySQL access speed

John Nagle nagle at
Tue Nov 17 07:31:25 CET 2009

Hans Müller wrote:
> Hello,
> I have some programs doing a lot sql IO in some mySQL databases.
> This works very fine and the DBAPI is quite simple to understand.
> Now I came to the point where I had to insert millions of lines into a table.

   If you're loading into an empty table, use the LOAD command.  That's
far faster than doing vast numbers of INSERT operations.  The
LOAD command loads all the data, unindexed, then builds the indices.
Expect a 10x speed improvement or better.

					John Nagle

More information about the Python-list mailing list