Re: Slow ORDER BY in MySQL v4.1.8

2005-01-05 Thread Jigal van Hemert
From: "Kelvin Wu" > 1, If I created table 'newtest' using InnoDB type, inserting 50k > records took me 20min! If I use MyISAM type, inserting took me less > then 1 min. I don't know much about InnoDB but how come the > performance is dropped down so much? Do read everything in the MySQL manual and

Slow ORDER BY in MySQL v4.1.8

2005-01-04 Thread Kelvin Wu
Hi list, I am thinking of upgrading to MySQL v4.1.8, I installed on my local machine(Windows XP). Copied tables from MySQL v3.23.xx to MySQL 4(eg, mytest.MYD, mytest.MYI, mytest.frm), it works just fine, query, sorting as usual. I created a new table (say 'newtest') with exactly same structure a