MySQL Forums
Forum List  »  Performance

Re: UPDATE - Increment Speed Question
Posted by: dbv
Date: April 05, 2005 09:23AM

>that tip is saying that it is better to use a separate table to keep a count of things

OK, I understand better now, thanks.

When keeping track of counts in a separate table, is it better to do the above-mentioned UPDATE, or to do an INSERT DELAYED and then count the results at a predetermined period?

Doing an UPDATE locks the table so I think an INSERT DELAYED would be better.

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
11395
dbv
April 04, 2005 09:44AM
3329
April 05, 2005 01:36AM
Re: UPDATE - Increment Speed Question
2794
dbv
April 05, 2005 09:23AM
2722
April 10, 2005 12:00PM
2592
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.