If you copy a MyISAM table with PRIMARY key, don’t forget to order the rows first

(Hazan Ilan) In a case that you copy (INSERT INTO .. SELECT ..) a MyISAM table that have a PRIMARY key, it is much faster to insert the new rows in the primary key order:

Read More - Register for Free Membership