> 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.
Is this an InnoDB database by any chance? If it is, and it is a clean
import, then disable the FOREIGN_KEY_CHECKS.
SET AUTOCOMM
Indexing can play a big role in the load time differential. When
loading .45 million rows, MySQL may be able to handle the sorting for
indexes in memory. With 5.5 million, it's more likely to have to go
to a temp file. You then could end up thrashing you disk, causing big
slow downs. If you
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 t