mySQL access speed
nagle at animats.com
Tue Nov 17 07:31:25 CET 2009
Hans Müller wrote:
> 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.
More information about the Python-list