Get PHP / MySQL command line to run faster
Posted by: wampuser (---.hsd1.ma.comcast.net)
Date: October 08, 2006 04:11PM

I am using WampServer to run PHP scripts which load a lot of raw data into a MySQL database. I'm running it from the command line. The nature of the data processing is that there are a lot of MySQL UPDATE statements. I'd say maybe there are about 40,000 updates to make every time I run it, and this is something I have to run every day.

Everything is working fine, but I was wondering about improving the speed. The performance isn't that bad (as a rough guess, maybe 50 of these queries a second?), but I am curious to know if there is anything I can tweak in order to speed this up.

Thanks,

Options: ReplyQuote


Sorry, only registered users may post in this forum.