Paul, what Alex is saying is that cftransaction is for data integrety - making sure the data doesn't get changed by another request while you're cfquery'ing away.
unless those 5 queries are heavily dependant on each other and might change by the time the last is run, cftransaction is a waste of cpu cycles. it's better suited for inserting a record and getting the PKey back (eg select @@identity, etc) or multiple updates or "select before delete", etc. cftransaction actually causes a performance hit (depending on the isolation type) so I can't see any speed performances. google away on cftransaction - there's not a great deal of nitty-gritty stuff (behind the scenes) but basic "how-to", there's lots of. check out mail-archive here on cf-dev or cfaussie or cfczone.org to clarify/support this hope this helps cheers barry.b ----- Original Message ----- From: "Alex Skinner" <[EMAIL PROTECTED]> Date: Tue, 3 Aug 2004 10:45:01 +0100 To: <[EMAIL PROTECTED]> Subject: RE: [ cf-dev ] <cftransaction> > Paul can I ask why you need to use cftransaction. What is the desired > functionality ? > > I can't see how it would increase speed. If you're on SQL Server you could > use a stored procedure with transactional logic with multiple result sets > but again depends what youre trying to do ? > > > Alex > > -----Original Message----- > From: Paul Swingewood [mailto:[EMAIL PROTECTED] > Sent: 03 August 2004 10: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] > > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.657 / Virus Database: 422 - Release Date: 13/04/2004 > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.657 / Virus Database: 422 - Release Date: 13/04/2004 > > > > > -- > 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] > -- ___________________________________________________________ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm -- 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]
