Re: UPDATE - Increment Speed Question
Posted by:
James Day
Date: April 10, 2005 12:00PM
UPDATE locks but it's very fast and you can use LOW PRIORITY if desired. You might use INSERT DELAYED if you have a client program which you want to return immediately, without waiting for the UPDATE to happen, as a way to give faster response to users.
If you don't need an exact result you can also do a count once an hour or once a day and save that value. Or could save in a heap table and update the main table record once every few minutes.
I'd do it with the update and change to the heap approach if the updates became a problem.
Subject
Views
Written By
Posted
11688
April 04, 2005 09:44AM
3969
April 04, 2005 03:40PM
3519
April 05, 2005 01:36AM
2954
April 05, 2005 09:23AM
Re: UPDATE - Increment Speed Question
2905
April 10, 2005 12:00PM
2767
April 11, 2005 05:24PM
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.