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]
