In a similar vein to Joe's problem, is it just me,
or does MySQL
performance on Windows *really* suck?
On my 3GHz athlon XP box, importing that cur table took around 26
hours, whereas the same job on an inferior linux box took around 8.
Similarly, the same SQL query to count the rows in the cur table takes
0.1 seconds on linux and 6 minutes on windows.
Surely MySQL on windows can't be *this* bad? Both MySQLs are running
as default 4.x installations on otherwise unladen machines with ample
RAM. Does this match others' experiences?
I just read that I'm supposed to do
Set AutoCommit = off
...bunch of inserts....
Commit
and that it should help the performance, since autoCommit is currently 1.
I'll report back after I try it