"Load Data Infile Replace ..." too slow

[mos]

I'm replacing 14 million rows of data using "Load data infile replace" and 
it is taking forever to complete. I killed it after 6.2 hours on an AMD 
3500 machine. I then deleted all the data from the table and used "Load 
data infile ignore" and it completed quite quickly in about 30 minutes.  Is 
there any way to speed up using "Load data infile replace"? TIA

Mike

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