<cfset time = 0 />
<cfloop index="i" from="1" to="1001">
    <cfquery name="queryname" datasource="zzCL" result="query">
        SELECT      aUsers.userId, aUsers.firstName + ' ' + aUsers.lastNAme AS name, aAccounts.accountName
        FROM        aUsers
        INNER JOIN  aUserAccounts ON aUserAccounts.userId = aUsers.userId
        INNER JOIN  aAccess ON aAccess.accessLevel = aUserAccounts.accessLevel
        INNER JOIN  aAccounts ON aAccounts.accountId = aUserAccounts.accountId
        WHERE       aUsers.userId = #i#
    </cfquery>
    <cfset time = time + #query.EXECUTIONTIME# />
</cfloop>

<cfdump var="query: #time#" /><br />

<cfset time = 0 />
<cfloop index="i" from="1" to="1001">
    <cfstoredproc procedure="usp_getData" datasource="zzCL" result="storeproc">
        <cfprocresult name="result" >
        <cfprocparam cfsqltype="CF_SQL_INTEGER" maxlength="100" value="#i#">
    </cfstoredproc>
    <cfset time = time + #storeproc.EXECUTIONTIME# />
</cfloop>

<cfdump var="storedproc: #time#" />