That's true - thank you for clarification.
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 12:25 PM
To: CF-Talk
Subject: RE: Annoying DB question
> try using a CFTRANSACTION like this...
>
> <cftransaction>
> <cfquery name="">
> EXECUTE sp_newmeal....
> </cfquery>
> </cftransaction>
>
> It is my understanding that the CFTRANSACTION will single
> thread ALL requests to the specified DB (instead of just
> row-level or table-level locks). That will prevent
> concurrent threads from inserting the same ID
I don't think that's correct. CFTRANSACTION doesn't single-thread all
requests to the DB - and a good thing, too. Instead, it tells the database
to treat the queries contained within the CFTRANSACTION tags as a single
transaction. How the database actually handles the transaction is up to the
database, to a degree - some databases may lock an entire table, others may
lock a page, others may lock a row. In addition, you can use the ISOLATION
attribute to specify the desired isolation level, which basically boils down
to how optimistic you are about the likelihood of concurrency issues, or
whether you even care about them.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
