I have a small script I wrote maybe 75 lines that does a select statement in mysql and steps through 5,000 products and then searches a csv file to fetch the products inventory. The script takes forever to run, about 1/2 an hour. I believe maybe if the csv file was loaded into any array it would go very quickly, dunno. I don’t have time to rewrite the script and I am looking for someone to speed it up for me.
I won’t be able to give you access to the mysql DB but I can give a copy of the csv file. But its only doing a single select statement for product id to make sure they match then doing an update to change the inventory amount field.
Thanks,
Chris Edwards