Are you doing single insert statements, multiple insert statements or LOAD DATA INFILE statements?
On 12/4/05, Chenzhou Cui <[EMAIL PROTECTED]> wrote: > Dear MySQL fans, > > I have a 260 GB huge file with 1045175762 rows. Two weeks ago, I wrote a > Java program to read the huge plain text file into MySQL 4.1.12. 300 > million of rows could be loaded in one day. > > Last Thursday, I updated the MySQL to 5.0.16 and then run the same > program. Only 225 million of rows can be loaded in one day. > > In additional to the version difference, the MySQL 4.1.12 was compiled > from SRPM packages from RedHat Updates, while the MySQL 5.0.16 is > installed directly using the MySQL binary RPM packages for Redhat AS 4. > > Any information and suggestion are welcome. > > Regards, > Chenzhou CUI > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]