Forum Moderators: open

Message Too Old, No Replies

MySQL, LOAD DATA LOCAL INFILE or mysqlimport

         

csdude55

5:06 am on Jan 5, 2016 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



I'm importing a text file with fixed-width columns, roughly 1G in size.

Which will be faster to process; using LOAD DATA LOCAL INFILE or mysqlimport --local? Either will be using in a PHP script, if that matters.