Total Time	Avg Time	Count	Template
78 ms	78 ms	1	D:\Inetpub\aaos75th\history.cfm
15 ms	15 ms	1	D:\Inetpub\aaos75th\skeleton_body.cfm
0 ms	0 ms	1	D:\Inetpub\aaos75th\Application.cfm
0 ms	0 ms	2	D:\Inetpub\aaos75th\modules\text_changecase.cfm
16 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
94 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

	SELECT tblLookupPageCategories.PageCategoryDefault, tblPages.PageCallname
	FROM tblPages INNER JOIN tblLookupPageCategories ON tblPages.PageID = tblLookupPageCategories.PageID INNER JOIN tblPageCategories ON tblLookupPageCategories.PageCategoryID = tblPageCategories.PageCategoryID
	WHERE tblPages.PageArchived != 'y'
	  AND tblPages.PageEnabled = 'y'
	  AND tblPageCategories.PageCategoryCallName = 'history'
	  AND tblPages.PageSiteID = 2
	  AND tblLookupPageCategories.PageCategoryDefault = 'y'

		SELECT tblPages.PageCallname, tblPages.PageContent, tblPages.PageURLForward
		FROM tblPages LEFT OUTER JOIN tblSites ON tblPages.PageSiteID = 2
		WHERE
		     (tblPages.PageArchived IS NULL) 
		  OR (tblPages.PageArchived <> 'y') 
		  AND (tblPages.PageEnabled = 'y') 
		  AND (tblSites.SiteID = 2) 
		  AND tblPages.PageCallName = 'living_history'
		ORDER BY tblPages.PageTitle
	

				WITH tblPageStructure(pagecategoryid, pageid, pageparentid, depth, sortcol)
				AS
				(
				-- anchor member
				SELECT tbllookuppagecategories.pagecategoryid, tblpages.pageid, tbllookuppagecategories.pageparentid, 0, CAST(tbllookuppagecategories.pageorder AS VARBINARY(900))
				FROM tblPageCategories
				INNER JOIN tblLookupPageCategories ON tblPageCategories.PageCategoryID = tblLookupPageCategories.PageCategoryID 
				INNER JOIN tblPages ON tblLookupPageCategories.PageID = tblPages.PageID
				WHERE PageParentID = 0
				UNION ALL
				-- recursive member
				SELECT lpc.pagecategoryid, lpc.pageid, lpc.pageparentid, ps.depth+1, CAST(sortcol + CAST(lpc.pageorder AS BINARY(4)) AS VARBINARY(900))
				FROM tblPageCategories pc
				INNER JOIN tblLookupPageCategories lpc ON pc.PageCategoryID = lpc.PageCategoryID 
				INNER JOIN tblPages P ON lpc.PageID = p.PageID
				JOIN tblPageStructure AS ps
				ON lpc.PageParentID = ps.PageID
				)
				-- outer query
				SELECT 
				tblPageCategories.PageCategoryID, tblPageCategories.PageCategoryCallName, tblPageCategories.PageCategoryTitle, tblPageCategories.PageCategoryAddress, tblPageCategories.PageCategoryOrder, tblPageCategories.PageCategoryChildren, tblPages.PageID, tblPages.PageTitle, tblPages.PageCallname, tblPages.PageURLForward, tblPages.PageList, tblPages.PageLinkDisable, tblPageStructure.pageparentid, tblPageStructure.depth AS PageDepth
				FROM tblPageStructure
				INNER JOIN tblPageCategories ON tblPageStructure.PageCategoryID = tblPageCategories.PageCategoryID
				INNER JOIN tblPages ON tblPageStructure.PageID = tblPages.PageID
				WHERE tblPages.PageArchived <> 'y' 
				  AND tblPages.PageEnabled = 'y'
				  AND tblPages.PageSiteID = 2
				  AND tblPageCategories.PageCategoryEnabled = 'y'
				  AND tblPageCategories.PageCategoryArchived <> 'y'
				ORDER BY PageCategoryOrder, PageCategoryID, sortcol
			

					SELECT tblPages.PageSponsor
					FROM tblPages
					WHERE tblPages.PageArchived != 'y'
					  AND (tblPages.PageEnabled = 'y') 
					  AND tblPages.PageCallName = 'living_history'
				

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\Inetpub\aaos75th\history.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=image/gif, image/jpeg, image/pjpeg, image/pjpeg, application/x-shockwave-flash, application/x-ms-application, application/x-ms-xbap, application/vnd.ms-xpsdocument, application/xaml+xml, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*
HTTP_ACCEPT_ENCODING=gzip, deflate
HTTP_ACCEPT_LANGUAGE=en-us
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=CFID=1214304; CFTOKEN=16213113
HTTP_HOST=www.aaos75th.org
HTTP_REFERER=http://www.aaos75th.org/index.cfm
HTTP_USER_AGENT=Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; GTB7.3; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; InfoPath.2; .NET4.0C; .NET4.0E)
PATH_INFO=/history.cfm
PATH_TRANSLATED=D:\Inetpub\aaos75th\history.cfm
QUERY_STRING=
REMOTE_ADDR=10.1.3.3
REMOTE_HOST=10.1.3.3
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/history.cfm
SERVER_NAME=www.aaos75th.org
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=

Client Variables:
cfid=1214304
cftoken=16213113
hitcount=85
lastvisit={ts '2012-03-26 09:56:24'}
timecreated={ts '2011-03-23 10:40:28'}
urltoken=CFID=1214304&CFTOKEN=16213113

Cookie Variables:
CFID=1214304
CFTOKEN=16213113

Session Variables:
cfid=1214304
cftoken=16213113
sessionid=AAOS75THCELEBRATORY_PUBLIC_1214304_16213113
urltoken=CFID=1214304&CFTOKEN=16213113