need to update 150K+ records

[bliss322]

i have a quantity file of 150K+ records that need to update the mysql database at least once a day (ideally twice)

using php on the command line to run through the file is taking WELL over 2 hours to run all the updates.

so, i'm looking for suggestions on how i could speed this process up.

any suggestions?

[jayant]

what kind of update is it?

you can directly run mysql via command line and run the querries

[bliss322]

it's a quantity update. all 150K+ records get their quantities updated based on product ID

so, if i could run mysql command via the command line...

should i use php to parse this tab delimited text file (the quantity update file) to create a sql file and then use bash to execute the mysql commands?

[Sxooter]

Are you basically replacing all the values in the table, or updating parts or what?

If it's basically a bulk update, there might be quicker /easier methods like bulk loading a table.