And now to inject a little more uncertainty... Just a couple of months ago an Allaire consultant told me that cfloop was the second slowest tag after cfmail. Always use cfoutput to output queries. I imagine he was speaking relatively though. I can think of some really slow tags.
jon ----- Original Message ----- From: "Critter" <critter@cfresume.org> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Wednesday, May 09, 2001 1:37 PM Subject: Re: cfloop vs cfoutput
> Hello Kola, > > This is from the Certified ColdFusion Developer Study Guide: > > pg 37 Tip #1 > > <crit_quote> > > The function of the query loop is the same as using <cfoutput> with a query attribute. For > performance reasons, use a Query loop rather than a <CFOUTPUT query="qAny"> loop. Before > ColdFusion 4.x, the <CFoutput query="qAny"> query loop performed better. > > Generally speaking you should use a <cfloop> with a query attribute when doing all, or > mostly, processing in the loop. If there is nothing in the loop but display, use > <cfoutput> > > > </crit_quote> > > So what's right? > > -- > Best regards, > Critter > ------------------------------------------- > Wednesday, May 09, 2001, 11:50:56 S2k, you wrote: > > > KO> Sorry for the crosspost (had conflicting answers from other lists) > > KO> but is there a consensus on which method of looping over a query is fastest? > > KO> cfloop or cfoutput.. > > KO> Cheers > > KO> KOLa > > > KO> >