Re: Slow UPDATE's on a large table

[Srdan Dukic]

* Is statusId ever NULL?

StatusId is never NULL. This column should have been made NOT NULL.

* How much RAM do you have?

There's 4GB of RAM on the server. The only other programs it's running are two low-volume websites on Apache.

* "The update works by finding the 'BaseMessageId'" -- Is this inside the UPDATE loop or not?

Yes. I meant that 'BaseMessageId' is used in the WHERE clause

* localhost? LAN? WAN? 1002 hops to the server might be noticeable if there is a big network delay.

localhost.

I will try re-writing the UPDATE to use the list method and report back the results.