drop php for cronjobs with mysql

[fr8]

I have a few cronjobs that run through my database. some hourly while others are every half hour. each has its own set of objectives to complete. when they run they take about 1-2 mins to complete. They all basicly read a row and based on what is read it then updates that row. This happens roughly 65,000+ times every half hour.

My question is since this takes so long to complete and the site becomes slow as a dog. Should I look at another language to run the updates on mysql?

[Yegg]

seems like the slow speed it's the result of none otpmized SQL clauses, but no PHP script, if you could post here table structures and PHP scripts u use. I could help you to optimize it.