updating 145K records twice a day, advice needed
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?
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.