how do I indentify which section of code is slow?

[braseth]

I have a query that loops over several CFIF statements. The page seems to be
rendering too slow. Is there a way where I can put some code around several
blocks of code, to display the amount each block is taking to process? The
debugger gives me a total, but I'm trying to isolate sections. I am using CFMX 6

[CF_DAWG]

If you were using CFMX 7, I could tell you to use the <cftimer> tag, but how
about doing it this way instead. You could output the time before your code
executes and after it is done. Like this:

<cfoutput>#now()#</cfoutput>
execute your slow code
<cfoutput>#now()#</cfoutput>

You could do calculations on it to, like:
<cfset variables.before = now()>
execute your slow code
<cfset variables.totalTime = now() - variables.before>
<cfoutput>#variables.totalTime#</cfoutput>

Hope this helps!

[CF_DAWG]

You can also use the <cftrace> tag and it will return more information than my code from my previous post. Look in your documentation for more syntax on <cftrace>.

[OldCFer]

You could use GetTickCount() to time code blocks

<cfset Start = GetTickCount()>
Slow code block
<cfset TimeToRun = GetTickCount() - Start>
<cfoutput> It took #timeToRun# milliseconds to run the code</cfoutput>