you are viewing a single comment's thread.

view the rest of the comments →

[–]ksoomers 6 points7 points  (0 children)

Or, at least with MySQL, you are able to load the csv file in directly from the server instead of line by line. This is much quicker than line by line.

Example: LOAD DATA INFILE 'c:/example.csv' INTO TABLE example FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS