MySQL Forums
Forum List  »  MyISAM

Re: Slow UPDATE's on a large table
Posted by: Srdan Dukic
Date: June 27, 2010 10:36PM

* 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.

Options: ReplyQuote


Subject
Views
Written By
Posted
14732
June 24, 2010 10:11PM
6252
June 27, 2010 02:57PM
5424
June 27, 2010 09:16PM
5591
June 27, 2010 09:47PM
Re: Slow UPDATE's on a large table
4228
June 27, 2010 10:36PM
4142
June 27, 2010 11:52PM
3888
June 28, 2010 08:38PM
4022
July 04, 2010 08:28PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.