Well this hilarious!
The test proved me wrong!
It takes longer when I do specify the scope for the query, see test below.
Since your test involves generating HTML in the loop, I'd question the reliability of the numbers. I changed the contents of each loop to an assignment statement:
<cfset a="#id# #test#<br/>"/> (appropriately for each loop)
Running the test many many times produced inconclusive results. Sometimes one format was faster, sometimes another:
1493 1144 1268
1328 1153 1262
1572 1092 1383
1171 1183 1228
Also, you weren't testing recordCount which was your original question. I changed the test to loop 5000 times over these statements respectively:
<cfset a = qTest.recordCount/> <cfset a = variables.qTest.recordCount/>
And the results? Well, inconclusive again. Sometimes one was faster, sometimes the other was faster.
Sean A Corfield -- http://www.corfield.org/blog/
"If you're not annoying somebody, you're not really alive." -- Margaret Atwood
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
