List:General Discussion« Previous MessageNext Message »
From:Krishna Chandra Prajapati Date:November 28 2009 6:09am
Subject:Re: INSERT DATA INTO TABLE
View as plain text  
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 <mos99@stripped> 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=1
>
>

Thread
INSERT DATA INTO TABLEKrishna Chandra Prajapati27 Nov
  • Re: INSERT DATA INTO TABLEmos27 Nov
    • Re: INSERT DATA INTO TABLEKrishna Chandra Prajapati28 Nov
      • Re: INSERT DATA INTO TABLEmos28 Nov