MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: updating 145K records twice a day, advice needed
Posted by: Mike Hillyer
Date: April 06, 2005 10:49PM

Have you thought of using LOAD DATA INFILE to move your updates into a temporary table?

I can import 3 million rows from a text file using LOAD DATA in 8 seconds.

http://dev.mysql.com/doc/mysql/en/load-data.html

Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: +1 403-380-6535
Mobile: +1 403-330-0870
Blog: http://www.openwin.org/mike

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
updating 145K records twice a day, advice needed
matthew collins
April 06, 2005 08:16PM
Re: updating 145K records twice a day, advice needed
Mike Hillyer
April 06, 2005 10:49PM
Re: updating 145K records twice a day, advice needed
matthew collins
April 07, 2005 06:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.