thuận bùi
thuận bùi

Reputation: 11

Should I import 1 million rows at 1 time or import 1 million time 1 row to MySQL?

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

Answers (0)

Related Questions