I'm not an expert on transaction integrity and the like, but wouldn't
CFTRANSACTION have no bearing on the retrieval of a newly inserted record?
The possibility will still exist that a newer record has been inserted
between the time of the "new" record, and the GET MAX query.
----- Original Message -----
From: "Bryan Love" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, August 14, 2001 2:24 PM
Subject: RE: cftransaction
> No.
>
> Cftransaction forces the DB to operate in single-thread mode. The only
> realistic reason to use it is if you are using a GET MAX query to retrieve
> the ID of a freshly inserted record. Using it anywhere else would only
slow
> the DB down. The major reason that enterprise-level DBs are so fast is
> because they are multi-threaded (ACCESS is not). Don't cripple your DB
with
> CFTRANSACTION
>
>
> Bryan Love ACP
> Internet Application Developer
> Telecommunication Systems Inc.
> [EMAIL PROTECTED]
>
>
>
> -----Original Message-----
> From: John Barleycorn [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 14, 2001 9:51 AM
> To: CF-Talk
> Subject: cftransaction
>
>
> Hello, is there ever a reason to use cftransaction around a single query?
I
> currently use it around queries that are dependant on each other, but
> another coder is using cftransaction around single queries. Just wondering
> if this is correct or just a waste. thanks.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
