mySQL access speed

[John Nagle]

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