I'm loading 100 million rows into a MyISAM table and I'm wondering what overhead is there when using the "Load Data Infile REPLACE " over "Load Data Infile Ignore" syntax.

For example, does the REPLACE do a lookup prior to inserting the row? Would it be faster to use Ignore? There is no possibility of having duplicate unique keys so I'm wondering if one syntax has a speed benefit over the other. TIA

Mike


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to