hi ,
I am using the Load Infile utility to load data from file to MySQL DB.
When trying to load different amounts of data, I observed a notable
difference in the time taken by that.
Test 1
Amount of data - 5.5 million rows. Time Taken - 6+hrs Approximately.
Test2
Amount of data - 0.45 million rows. Time Taken - 2 mins approximately.
Can some one explain why this difference is coming. Also it will be great if
someone can suggest how we can improve the performance of the first test.
Thank you
sujay
