QoQ.cfm

<cfscript>
max=10000;

persons = queryNew(
		"lastname, firstname",
		"cf_sql_varchar, cf_sql_varchar",
		[
			[ "Lebowski", "Jeffrey" ],
			[ "Lebowski", "Bunny" ],
			[ "Lebowski", "Maude" ],
			[ "Sobchak", "Walter" ]
		]
	);


// Query of Query
start=getTickCount();
for (i = 1; i <= max; i++) {
	queryExecute(
		"select * from persons
		where lastname='Lebowski'
		and firstname='Bunny'
		order by lastname ", 
		{},
		{dbtype="query"}
	);
}

writeoutput("Query of Query Execution Time:"&(getTickCount()-start));	
// Query Filter/Sort
start=getTickCount();
for (i = 1; i <= max; i++) {
	qf=queryFilter(persons,function (row,cr,qry) {return row.firstname=='Bunny' && row.lastname=='Lebowski';});
	qs=qf.sort(function(rowA, rowB) { return compare(rowA.lastname, rowB.lastname); });
}
writeoutput("<br>Query Filter/Sort Execution Time:"&(getTickCount()-start));
</cfscript>