Re: Slow UPDATE's on a large table
* 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.
Subject
Views
Written By
Posted
14899
June 24, 2010 10:11PM
6340
June 27, 2010 02:57PM
5511
June 27, 2010 09:16PM
5682
June 27, 2010 09:47PM
Re: Slow UPDATE's on a large table
4306
June 27, 2010 10:36PM
4227
June 27, 2010 11:52PM
3974
June 28, 2010 08:38PM
4130
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.