How I can Load 15 Crores record dndlist into a table Effeciently using LOAD DATA

See more:

SQL

MySQL

Hi All,

I have a table (dndlist) having columns (serviceareacode,phone,preferences,ostype,phonetype) In MYSQL 5.0 Database.

I have 16 csv files each containing 10000000 records and file size is avg (284 MB).

Currently I am using MYSQL "LOAD DATA" utility to import data. The example is :

LOAD DATA LOCAL INFILE 'E:\\TRAI\\trai0.csv'
INTO TABLE trai1   FIELDS TERMINATED BY "," ENCLOSED BY '"'  LINES  TERMINATED BY '\n'
(serviceareacode,phone,preferences,ostype,phonetype);

The above code is taking 5- 6 hours for each file to upload.

Please anybody suggest me how I can Insert,search as well as update records efficiently

I am waiting for your valuable response.

Thanks all.

EDIT
-------------
FYI 15 Crore = 150 million