Efficiant way to do multiple mysql updates

[marky2coats]

Hi,

I have a PHP script that updates 2 mysql tables with SMS delivery reports. This can mean that the script could be updating thousands of rows (seqeuntialy) at any one time.

Is there anyway to do a batch update?. At the moment the script is executeing thousands of UPDATE table queries which is realy ineffciant and slow.

Can anybody shed some light on a more efficiant way?

Cheers,

Mark.