Read-committed won't be strong enough for the purposes of incrementing a counter; it is actually the _default_ isolation level in most databases! All that Read-committed does is says that no other operation can modify a row while the current transaction is reading it - as soon as the read is done, other operations are free to modify that row. This means other operations can update that row. In the case of a counter, you need to read the row and then update it, ensuring that no other operation modifies that data before you update it. That requires at least Repeatable-read, and depending on how the counter is implemented, Serializable.
Roland -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Xavi Sent: Thursday, January 20, 2005 4:01 AM To: [email protected] Subject: Re: [CFCDev] cftransaction sql server isolation Serializable locks whole table, will be better and less overhead Read Committed. On Wed, 19 Jan 2005 11:58:17 -0500, Roland Collins <[EMAIL PROTECTED]> wrote: > > > > Serializable. > > > > http://www.macromedia.com/devnet/mx/coldfusion/articles/cftransaction.html > > > > > > > > ________________________________ > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Joe Ferraro > Sent: Wednesday, January 19, 2005 11:33 AM > To: [email protected] > Subject: [CFCDev] cftransaction sql server isolation > > > > > This should be a simple question. > > > > I need to get a counter from the database and update it and I need to be > sure that other apps must wait to get the counter until I'm done with the > update. Which isolation level is right for this? -- Xavi (http://xavicl.blogspot.com) ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
