> Some locking hits are row based:
>
> SELECT column
> FROM table WITH (ROWLOCK).
i stand corrected.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
> > > Ooops I meant "suggest locking" not "suggest isolation
> > > levels". You can of course set isolation levels in CF and
> > > this is the way CF recommends locking type to the DB.
> >
> > Again, though, I don't think this is a recommendation - I'm
> > pretty sure that whatever you choose f
Well, this isn't strictly true either. Some databases can escalate locks
above what you've specified - this is usually a good thing though.
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: December 24, 2003 1:32 PM
To: CF-Talk
Subject: RE: CFTRANSACTIO
Believe it or not, the book is wrong.
-Original Message-
From: Tom Kitta [mailto:[EMAIL PROTECTED]
Sent: January 8, 2004 1:15 PM
To: CF-Talk
Subject: Re: CFTRANSACTION & CFLOCK
I am just saying what I read in "Certified Cold fusion developer study
guide" by Ben Forta
Tom Kitta wrote:
> I am just saying what I read in "Certified Cold fusion developer study guide" by Ben Forta. page 161 top - "SERIALIZABLE is the highest isolation level provided by a database and is the defalut." If you are absolutely sure that this is not the case tell Ben about it.
The standar
> Ooops I meant "suggest locking" not "suggest isolation
> levels". You can of course set isolation levels in CF and
> this is the way CF recommends locking type to the DB.
Again, though, I don't think this is a recommendation - I'm pretty sure that
whatever you choose for your isolation level w
To: CF-Talk
Subject: Re: CFTRANSACTION & CFLOCK
> > Actually, you can only suggest isolation levels to DB, the DB
> > is the one that sets isolation levels and does what it think
> > is the best thing.
>
> While I imagine this could be true for some database, it certai
--- Original Message -
From: Kwang Suh
To: CF-Talk
Sent: Wednesday, December 24, 2003 1:39 PM
Subject: RE: CFTRANSACTION & CFLOCK
No, serializable is not the default level. Automatically serializing
transactions would be a huge performance killer.
-Original Messag
> Well, in fact, you probably will need cflock around this _if_
> the database does not support serialized transactions.
I think this would depend on the granularity of the locks within the
database. If you were using Access, again, I think this would work fine with
the default isolation level of
, 2003 9:44 AM
To: CF-Talk
Subject: RE: CFTRANSACTION & CFLOCK
> I have piece of code below:
>
>
>
> INSERT INTO tbl_Main (adadadadadadadada)
>
No, serializable is not the default level. Automatically serializing
transactions would be a huge performance killer.
-Original Message-
From: Tom Kitta [mailto:[EMAIL PROTECTED]
Sent: December 24, 2003 9:55 AM
To: CF-Talk
Subject: RE: CFTRANSACTION & CFLOCK
"If you're us
Some locking hits are row based:
SELECT column
FROM table WITH (ROWLOCK).
-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED]
Sent: December 24, 2003 10:23 AM
To: CF-Talk
Subject: Re: CFTRANSACTION & CFLOCK
> > Actually, you can only suggest isolation levels
> > Actually, you can only suggest isolation levels to DB, the DB
> > is the one that sets isolation levels and does what it think
> > is the best thing.
>
> While I imagine this could be true for some database, it certainly isn't
> true for either SQL Server or Oracle. I don't even think it's true
> Actually, you can only suggest isolation levels to DB, the DB
> is the one that sets isolation levels and does what it think
> is the best thing.
While I imagine this could be true for some database, it certainly isn't
true for either SQL Server or Oracle. I don't even think it's true for
loc
e-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 24, 2003 11:44 AM
To: CF-Talk
Subject: RE: CFTRANSACTION & CFLOCK
> I have piece of code below:
>
>
>
> INSERT INTO tbl_Main (adadadadadadadada)
> I have piece of code below:
>
>
>
> INSERT INTO tbl_Main (adadadadadadadada)
> VALUES (dadadadadadad)
>
>
> SELECT MAX ID from tbl_Main
>
>
>
Hi All,
I have a quick question:
I have piece of code below:
INSERT INTO tbl_Main (adadadadadadadada)
VALUES (dadadadadadad)
SELECT MAX ID from tbl_Main
17 matches
Mail list logo
