Hi Mos, In the below two command does 1 is faster than 2.
* 1. LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet;* 2. *LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet* *LINES TERMINATED BY '\r\n' enclosed by '"';* Thanks, Krishna Ch. Prajapati On Sat, Nov 28, 2009 at 3:50 AM, mos <mo...@fastmail.fm> wrote: > At 07:40 AM 11/27/2009, Krishna Chandra Prajapati wrote: > >> Hi Experts, >> >> load data local infile and insert into <tablename> are the two methods of >> inserting data into a mysql table. >> >> Out of the above two method. Is there any faster method of inserting data >> into mysql tables. >> > > No. Load Data is the fastest method, unless the data is already stored in > another table. > > Tip: Remember when using Load Data, it will be faster if the table is empty > and optimized (no holes) than with a table that has data in it. That's > because the non-unique indexes are built after all of the data has been > loaded. The alternative is to disable the non-unique indexes prior to using > Load Data. Unfortunately there is no way to disable the building of unique > indexes during this process unless you remove the unique index prior to > loading the data and building it later. > > Tip: Using Insert will be much slower than Load Data but you can speed it > up by loading dozens of rows using one Insert statement. > > Hope these tips help. > > Mike > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com > >
