im running a query wich imports 500k records into a table from a .CSV file. The query is running for 1h15min, i think is taking way to much time to do this. I was expecting about 10, 20 min. I've already did a insert query of 35k and it took about 30 seconds. Is there a way of speeding up the process?
The statement I'm calling is the one bellow:
LOAD DATA LOCAL INFILE 'c:/users/migue/documents/www/mc-cron/excels/BD_YP_vFinal_2.csv' INTO TABLE leads FIELDS TERMINATED BY ';' ENCLOSED BY '"' LINES TERMINATED BY '\n';
Thanks.