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 comm
> ... But it isn't very fast.
> For executemany I have some hundred thousend lines in a list of tuples.
> I joined() these lines to form an insert into table values () statement
> and
> blew it into the mysql cmdline client via os.popen().
> This was 60(!) times faster and loaded my table in s
