Yes, there are indexes on the table. Do you mean to say index is the culprit.
sujay -----Original Message----- From: Peter J Milanese [mailto:[EMAIL PROTECTED] 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
