document.write('
Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. <cfset time = 0 />
  2. <cfloop index="i" from="1" to="1001">
  3.     <cfquery name="queryname" datasource="zzCL" result="query">
  4.         SELECT      aUsers.userId, aUsers.firstName + \' \' + aUsers.lastNAme AS name, aAccounts.accountName
  5.         FROM        aUsers
  6.         INNER JOIN  aUserAccounts ON aUserAccounts.userId = aUsers.userId
  7.         INNER JOIN  aAccess ON aAccess.accessLevel = aUserAccounts.accessLevel
  8.         INNER JOIN  aAccounts ON aAccounts.accountId = aUserAccounts.accountId
  9.         WHERE       aUsers.userId = #i#
  10.     </cfquery>
  11.     <cfset time = time + #query.EXECUTIONTIME# />
  12. </cfloop>  
  13.  
  14. <cfdump var="query: #time#" /><br />
  15.  
  16. <cfset time = 0 />
  17. <cfloop index="i" from="1" to="1001">
  18.     <cfstoredproc procedure="usp_getData" datasource="zzCL" result="storeproc">
  19.         <cfprocresult name="result" >
  20.         <cfprocparam cfsqltype="CF_SQL_INTEGER" maxlength="100" value="#i#">
  21.     </cfstoredproc>
  22.     <cfset time = time + #storeproc.EXECUTIONTIME# />
  23. </cfloop>
  24.  
  25. <cfdump var="storedproc: #time#" />
');