ColdFusion MX Debugging

Debugging Details

	Exceptions
	Exceptions (none present)

#cfdebug_ex.template#(#cfdebug_ex.line#) @ #TimeFormat(cfdebug_ex.timestamp, "HH:mm:ss.lll")#
type	#cfdebug_ex.name#
message	#cfdebug_ex.message#

General

SELECT (endTime - startTime) AS executionTime FROM qEvents WHERE type = 'ExecutionTime' SELECT sum(endTime - startTime) AS executionTime FROM qEvents WHERE type = 'Template' AND parent = ''

Execution Times

// SELECT stacktrace will result in Query Of Queries runtime error. // Failed to get meta_data for columnqEvents.stacktrace . // Was told I need to define meta data for debugging event table similar to if( qEvents.type eq "template" ) { st = structNew(); st.StackTrace = qEvents.stackTrace; st.template = qEvents.template; st.startTime = qEvents.starttime; st.endTime = qEvents.endtime; st.parent = qEvents.parent; st.line = qEvents.line; arrayAppend(a, st); } if( a[i].stacktrace.tagcontext[x].id NEQ "CF_INDEX" ) { // keep appending the line number from the template stack to form a unique id childIdList = listAppend(childIdList, a[i].stacktrace.tagcontext[x].line); if( x eq 1 ) { parentIdList = listAppend(parentIdList, a[i].stacktrace.tagcontext[x].template); } else { parentIdList = listAppend(parentIdList, a[i].stacktrace.tagcontext[x].line); } } // template is the last part of the unique id...12,5,17,c:\wwwroot\foo.cfm // if we don't remove the "CFC[" prefix, then the parentId and childId relationship // will be all wrong startToken = "CFC[ "; endToken = " | "; thisTemplate = a[i].template; startTokenIndex = FindNoCase(startToken, thisTemplate, 1); if( startTokenIndex NEQ 0 ) { endTokenIndex = FindNoCase(endToken, thisTemplate, startTokenIndex); thisTemplate = Trim(Mid(thisTemplate,Len(startToken),endTokenIndex-Len(startToken))); } childIdList = listAppend(childIdList, thisTemplate); queryAddRow(qTree); querySetCell(qTree, "template", a[i].template); querySetCell(qTree, "templateId", childIdList); querySetCell(qTree, "parentId", parentIdList); querySetCell(qTree, "duration", a[i].endtime - a[i].starttime); querySetCell(qTree, "line", a[i].line); // empty parent assumed to be top level with the exception of application.cfm if( len(trim(parentId)) eq 0 ){ parentId = 0; } stTree[parentId] = structNew(); stTree[parentId].templateId = qTree.templateId; stTree[parentId].template = qTree.template; stTree[parentId].duration = qTree.duration; stTree[parentId].line = qTree.line; stTree[parentId].children = arrayNew(1); stTree[templateId] = structNew(); stTree[templateId].templateId = qTree.templateId; stTree[templateId].template = qTree.template; stTree[templateId].duration = qTree.duration; stTree[templateId].line = qTree.line; stTree[templateId].children = arrayNew(1); arrayAppend(stTree[parentId].children, stTree[templateId]); SELECT parentId, template FROM qTree WHERE parentId = '' #drawTree(stTree,-1,topNodes.template,cfdebugger.settings.template_highlight_minimum)#

(#time_other# ms) STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
(#cfdebug_execution.executionTime# ms) TOTAL EXECUTION TIME
red = over #cfdebugger.settings.template_highlight_minimum# ms execution time

SELECT template, Sum(endTime - startTime) AS totalExecutionTime, count(template) AS instances FROM qEvents WHERE type = 'Template' group by template order by totalExecutionTime DESC " & template & ""> "> ">

Total Time	Avg. Time	Count	Template

#totalExecutionTime# ms	#templateAverageTime# ms	#instances#	#templateOutput#

#time_other# ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN

#cfdebug_execution.executionTime# ms			TOTAL EXECUTION TIME

red = over #cfdebugger.settings.template_highlight_minimum# ms average execution time

	Execution Times (none present)

SQL Queries

	SQL Queries (none present)

	Stored Procedures

#cfdebug_storedproc.template# @ #TimeFormat(cfdebug_storedproc.timestamp, "HH:mm:ss.lll")#

procedure

#cfdebug_storedproc.name#

datasource

#cfdebug_storedproc.datasource#

execution time

#Max(cfdebug_storedproc.executionTime, 0)#ms

Parameters

Results

	Stored Procedures (none present)

	Scope Variables

CFTimer Times

Debugging Time: #duration# ms