RE: Major Difference in response times when using Load Infile uti lity

[Sujay Koduri]

Yes, there are indexes on the table. Do you mean to say index is the
culprit.

sujay 

-----Original Message-----
From: Peter J Milanese [mailto:PMilanese@stripped] 
Sent: Tuesday, September 13, 2005 4:58 PM
To: Sujay Koduri; mysql
Subject: Re: Major Difference in response times when using Load Infile
utility

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.