Hi Steve, That KB article http://www.macromedia.com/v1/Handlers/index.cfm?ID=2497&Method=Full is for CF Server 3.1... And as people have pointed out, there was a shift in 4.5 to make the cfoutput/cfloop difference nominal. So I'd consider that information, well... dated.
We tend to put a <cfsetting enablecfoutputonly="yes"> at the top of every page and begin all our CF processing and then put a cfoutput ride before we start any HTML output. Then close cfoutput at the bottom of the page. Everything inside the output is then available for CF use and we don't have to think about whether we need to add yet another cfoutput tag around one line here or there. All queries are cflooped and we find performance to be just fine. Maybe we would save a millisecond or two with opening and closing cfoutput tags throughout the page but it's not really worth it. Cheers, t ********************************************************************** Tyler M. Fitch Certified Advanced ColdFusion 5 Developer http://isitedesign.com ********************************************************************** -----Original Message----- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Friday, February 01, 2002 1:08 PM To: CF-Talk Subject: RE: Best Practice on using/optimizing cfoutput and cfloops This is directly from the Knowledge base on macromedia. CFOUTPUT vs. CFLOOP Use a CFOUTPUT query instead of CFLOOP query wherever possible. A loop over a query repeats for every record in the query result set. The CFLOOP results are just like a CFOUTPUT. During each iteration of the loop the columns of the current row will be available for output. The advantage of using CFLOOP instead of a CFOUTPUT is that you can use any CFML tag within a CFLOOP. CFOUTPUT is restricted to a limited number of tags to increase its performance. http://www.macromedia.com/v1/Handlers/index.cfm?ID=2497&Method=Full ______________________ steve oliver atnet solutions, inc. http://www.atnetsolutions.com ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
