Paul, Only use CFTRANSACTION if a] you are inserting data and b] you are inserting into several dependant tables such as inserting a user and their basket details OR c] you are deleting data that is dependant.
A good example of using CFTRANSACTION is to transfer amounts from one account to another such as a high score or something. To transfer the data you first take to amount out of record 1 then insert it into record 2. If the process fails after taking the amount out of record 1 it becomes lost somewhere in the ether. With CFTRANSACTION the process would have to complete 100% before the transaction is committed i.e. record 1 is not deleted until record 2 is accepted. Hope this clears it up. Ellis Wood Ellwood Web Solutions -----Original Message----- From: Paul Swingewood [mailto:[EMAIL PROTECTED] Sent: 03 August 2004 09:22 To: [EMAIL PROTECTED] Subject: [ cf-dev ] <cftransaction> I have 5 queries which populate drop down lists. I have just been reading up on <cftransaction>. Should I put all of these queries inside a <cftransaction> tag? - Does this increase speed? - How & why? I don't think I need all this rollback stuff as I am only reading to populate dropdown lists. Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
