MySQL Forums
Forum List  »  Performance

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
11533
dbv
April 04, 2005 09:44AM
3422
April 05, 2005 01:36AM
2867
dbv
April 05, 2005 09:23AM
Re: UPDATE - Increment Speed Question
2809
April 10, 2005 12:00PM
2682
dbv
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.