TryCF Gist

trycf-gist-1674376682957-84dd4721-bfaa-ccf5-6acc-801c650edc7f.cfm

<cfscript>
// init
q = queryNew( 'val' );
for ( i = 1; i <= 10000; i++ ) {
	q.addRow( {val = randRange( 1, 1000 ) } );
}
log = [=];

// reduce()
t = getTickCount();
sum = q.reduce( function( r, row ) {
    return r + row.val;
}, 0 );
log['reduce'] = getTickCount() - t;

// each()
t = getTickCount();
sum = 0;
q.each( function( row ){
    sum += row.val;
} );
log['each'] = getTickCount() - t;

// for in
t = getTickCount();
sum = 0;
for ( row in q ) {
    sum += q.val;
}
log['for in'] = getTickCount() - t;

</cfscript>

<cfset t = getTickCount()>
<cfset sum = 0>
<cfloop query="q">
	<cfset sum += q.val>
</cfloop>
<cfset log['cfloop'] = getTickCount() - t>

<cfdump var="#log#">