Reputation: 11
I want to ask about the most effective way to import bulk data into CSV file
I have a relatively large CSV file, which has around 20 million rows, and I need to import them into MySQL. I know that there is a technique called LOAD DATA INFILE and many people see it as the fastest way to import bulk data in MySQl.
However, I want to ask whether there are any differences when I load 1 million rows at 1 time with 1 quarry versus when split the file and load to the database multiple times, for example 1 million or 100,000 or 10,000.
Upvotes: 0
Views: 131