CFOUTPUT over a query acts as a scaled down version of CFLOOP. If you're simply doing output of variables, it's better to use the first example. Much faster than CFLOOP.
-----Original Message----- From: Michael E. Carluen [mailto:[EMAIL PROTECTED]] Sent: Friday, February 01, 2002 1:43 PM To: CF-Talk Subject: Best Practice on using/optimizing cfoutput and cfloops I am wondering if anyone can advise if one practice (below) is more efficient than the other. Practice 1: Enclosing every instance on #variables# in cfoutput tags <body> <cfoutput query="query_name"> #query_variable# </cfoutput> </body> VERSUS Practice 2: Enclosing the entire code in a single cfoutput and use cfloop when necessary <body> <cfoutput> <cfloop query="query_name"> #query_variable# </cfloop> </cfoutput> </body> Any advise to demystify any 'performance penalties' would be appreciated. Thanks, Michael ______________________________________________________________________ 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
