Re: Major Difference in response times when using Load Infile utility

[Peter J Milanese]

Are there indexes on the table? Could be that.

------Original Message------
From: Sujay Koduri
To: mysql
Sent: Sep 13, 2005 5:24 AM
Subject: Major Difference in response times when using Load Infile utility

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


-----------------
Sent from my NYPL BlackBerry Handheld.