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.
Subject
Views
Written By
Posted
11684
April 04, 2005 09:44AM
3964
April 04, 2005 03:40PM
3516
April 05, 2005 01:36AM
Re: UPDATE - Increment Speed Question
2951
April 05, 2005 09:23AM
2903
April 10, 2005 12:00PM
2764
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.