Databases - Is the LOAD DATA statement faster than INSERT and how much?
The LOAD DATA statement could be 15 even 20 faster than an ordinary INSERT so you should consider to use it when intending to insert a lot of data The basic syntax of the LOAD DATA statement is shown below: LOAD DATA INFILE file_name INTO TABLE table_name