is there a processing difference in...

[daNewfie]

using

<cfoutput>#myQuery.Item1#</cfoutput>
<cfoutput>#myQuery.Item2#</cfoutput>
<cfoutput>#myQuery.Item3#</cfoutput>
<cfoutput>#myQuery.Item4#</cfoutput>

vs

<cfoutput query="myQuery>
#myQuery.Item1#
#myQuery.Item2#
#myQuery.Item3#
#myQuery.Item4#
</cfoutput>

 

[FALCONSEYE]

you can do
<cfset myStart = GetTickCount()>
<cfoutput>...</cfoutput>
....
<cfset myStop = GetTickCount()>
<cfset myTime = myStop - myStart>
<cfoutput>#myTime#</cfoutput>

<cfset myStart = GetTickCount()>
<cfoutput query="myQuery>
#myQuery.Item1#
#myQuery.Item2#
#myQuery.Item3#
#myQuery.Item4#
</cfoutput>
<cfset myStop = GetTickCount()>
<cfset myTime = myStop - myStart>
<cfoutput>#myTime#</cfoutput>

and see which one is faster. my quess is the second one is going to be faster ...
hope it helps..

http://www.jetansolutions.com

 

[r937]

there's a huge difference!

the first will print 4 values (from the current row of the query results)

the second will print 4 values as many times as there are rows in the query results

the only time it ever comes close is when the query returns only one row



r937.com | rudy.ca

 

[imstillatwork]

<cfset myStop = GetTickCount()>
<cfset myTime = myStop - myStart>
<cfoutput>#myTime#</cfoutput>

Or

<cfoutput>#GetTickCount() - mystart#</cfoutput>

Just funny because I found myself doing all kinds of things like that the other day, and once was actually exactly this situation!

Kevin

http://www.lot-o-nothin.com/cfml/