Surgery: Asaid S. Abd. Sibreai

Total Time	Avg Time	Count	Template
15 ms	15 ms	1	F:\iisroot\SM6\SiteMaker\CustomTags\monte\PhotoLibrary.cfm
15 ms	15 ms	1	F:\iisroot\SM6\SiteMaker\websitefiles\montefio6278775\custom_scripts\photolibexecute.cfm
0 ms	0 ms	1	F:\iisroot\SM6\SiteMaker\websitefiles\montefio6278775\custom_scripts\Application.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
15 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

  select directoryName, DSN from esWebSite where siteID > 1

      exec usp_Photo_GetPhotoInfo 0, 115, '', 1
    

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=F:\iisroot\SM6\SiteMaker\websitefiles\montefio6278775\custom_scripts\photolibexecute.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=
HTTP_ACCEPT_ENCODING=deflate, gzip, x-gzip, compress, x-compress
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close, TE
HTTP_COOKIE=
HTTP_HOST=www.montefiore.org
HTTP_REFERER=
HTTP_USER_AGENT=ColdFusion
PATH_INFO=/custom_scripts/photolibexecute.cfm
PATH_TRANSLATED=F:\iisroot\SM6\SiteMaker\websitefiles\montefio6278775\custom_scripts\photolibexecute.cfm
QUERY_STRING=albumid=115&photoid=0
REMOTE_ADDR=127.0.0.1
REMOTE_HOST=127.0.0.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/custom_scripts/photolibexecute.cfm
SERVER_NAME=www.montefiore.org
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=

Server Variables:
COLDFUSION=Struct (8)
COLDFUSION.PROBES=Struct (2)
OS=Struct (5)

URL Parameters:
ALBUMID=115
PHOTOID=0