MySQL Forums
Forum List  »  General

updating 145K records twice a day, advice needed
Posted by: matthew collins
Date: April 06, 2005 08:16PM

i have to update a product inventory's quantities and prices that are supplied to us via a tab-delimited text file. the inventory needing to be updated, currently, is 145,000+ records.

to manage this, i use php to parse the suppliers text file and create a .sql file with the updates

UPDATE products set price=$price, quantity=$quantity where id = $id;

i then use a bash script to execute the .sql file

this method takes too long, the bash script has been running for 45 minutes now and is still running

does anyone have any suggestions on speeding this process up?

Options: ReplyQuote


Subject
Written By
Posted
updating 145K records twice a day, advice needed
April 06, 2005 08:16PM


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.