Total Time	Avg Time	Count	Template
78 ms	78 ms	1	D:\inetpub\wwwroot\ritesite.com\ResumeDatabase\SiteMapping_specific_index_By_Function.cfm
47 ms	47 ms	1	D:/inetpub/wwwroot/ritesite.com/ResumeDatabase/SiteMapping_specific_index_GetResumes_By_Function.cfm
31 ms	31 ms	1	D:/inetpub/wwwroot/ritesite.com/ResumeDatabase/inc/SiteMapping_specific_resultsInc_ByFunction.cfm
0 ms	0 ms	1	D:/inetpub/wwwroot/ritesite.com/Application.cfm
0 ms	0 ms	1	D:/inetpub/wwwroot/ritesite.com/gbl/execLoggedOff_SITEMAP.cfm
0 ms	0 ms	1	D:/inetpub/wwwroot/ritesite.com/gbl/site.cfm
0 ms	0 ms	1	D:/inetpub/wwwroot/ritesite.com/gbl/sitemapping_resume_index_header.cfm
0 ms	0 ms	1	D:/inetpub/wwwroot/ritesite.com/gbl/sitemapping_site.cfm
0 ms	0 ms	1	D:/inetpub/wwwroot/ritesite.com/gbl/spSelectNamesByIDs.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
78 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

 SELECT SMGROUP_ID, SMGroup_Name, SMGroup_URL, SMGroup_Index_Page, 
 SMGroup_html_page_title_tag, SMGroup_meta_description, 
 SMGroup_meta_keywords, SMGroup_meta_Author, SMGroup_meta_robots, 
 SMGroup_html_page_heading_H1, SMGroup_SQL_Query, SMGroup_SQL_ResumeID_Query, SMGroup_Preferred_Function
 FROM SITEMAPU_Resume_ByFunction_Groups WHERE (SMGROUP_ID = 35)

 SELECT rs.ResumeID, rs.UniqueKey, rs.Title, rs.ShowGeo, rs.DatePosted, rs.DateUpdated, 
 rs.Summary, rs.Conceal, rs.ResumeAttached, cmp.Compensation, 
 c.CityID, c.CityName, s.State, s.StateName, r.RegionID, r.Region,
 dbo.SITEMAPU_Resume_ByFunction_Temporary_Title_Group_InKeyOrder.KeyPriority, 
 dbo.SITEMAPU_Resume_ByFunction_Temporary_Title_Group_InKeyOrder.TitleExpanded, 
 dbo.SITEMAPU_Resume_ByFunction_Temporary_Title_Group_InKeyOrder.KeyUsed
 FROM tblResume rs 
 INNER JOIN lutCompensation cmp ON rs.CompensationID = cmp.CompensationID
 INNER JOIN tblUser u ON rs.UserID = u.UserID
 INNER JOIN tblUrights ur ON u.Urights = ur.UrightsID
 INNER JOIN jntResumeIndPosCmp ripc ON rs.ResumeID = ripc.ResumeID
 INNER JOIN jntIndustryPosition indPos ON ripc.IndustryPositionID = indpos.IndustryPositionID
 INNER JOIN jntCityStateRegion csr ON rs.CityStateRegionID = csr.CityStateRegionID
 INNER JOIN lutRegion r ON csr.Region = r.RegionID
 INNER JOIN lutCity c ON csr.CityID = c.CityID
 INNER JOIN lutState s ON csr.State = s.State
 INNER JOIN dbo.SITEMAPU_Resume_ByFunction_Temporary_Title_Group_InKeyOrder ON rs.ResumeID = 
 dbo.SITEMAPU_Resume_ByFunction_Temporary_Title_Group_InKeyOrder.ResumeID
 WHERE rs.ResumeID IN ( SELECT DISTINCT ResumeID FROM SITEMAPU_Resume_ByFunction_Temporary_Title_Group_InKeyOrder )
 AND rs.DateInactive IS NULL 
 AND rs.DateDeleted IS NULL
 AND rs.DatePosted IS NOT NULL
 AND IsNull(rs.Frozen, 0) = 0
 AND rs.Conceal = 1
 ORDER BY dbo.SITEMAPU_Resume_ByFunction_Temporary_Title_Group_InKeyOrder.KeyPriority, 
 dbo.SITEMAPU_Resume_ByFunction_Temporary_Title_Group_InKeyOrder.TitleExpanded, 
 dbo.SITEMAPU_Resume_ByFunction_Temporary_Title_Group_InKeyOrder.KeyUsed

 SELECT PageID, UniqueKey, ResumeID,
 PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD,
 ChangeFreq_sitemap, PagePriority
 FROM SITEMAPU_Resume_ByFunction_Pages
 WHERE ResumeID = 2852 

 SELECT PageID, UniqueKey, ResumeID,
 PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD,
 ChangeFreq_sitemap, PagePriority
 FROM SITEMAPU_Resume_ByFunction_Pages
 WHERE ResumeID = 25414 

 SELECT PageID, UniqueKey, ResumeID,
 PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD,
 ChangeFreq_sitemap, PagePriority
 FROM SITEMAPU_Resume_ByFunction_Pages
 WHERE ResumeID = 54064 

 SELECT PageID, UniqueKey, ResumeID,
 PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD,
 ChangeFreq_sitemap, PagePriority
 FROM SITEMAPU_Resume_ByFunction_Pages
 WHERE ResumeID = 51474 

 SELECT PageID, UniqueKey, ResumeID,
 PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD,
 ChangeFreq_sitemap, PagePriority
 FROM SITEMAPU_Resume_ByFunction_Pages
 WHERE ResumeID = 69650 

 SELECT PageID, UniqueKey, ResumeID,
 PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD,
 ChangeFreq_sitemap, PagePriority
 FROM SITEMAPU_Resume_ByFunction_Pages
 WHERE ResumeID = 77727 

 SELECT PageID, UniqueKey, ResumeID,
 PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD,
 ChangeFreq_sitemap, PagePriority
 FROM SITEMAPU_Resume_ByFunction_Pages
 WHERE ResumeID = 71139 

 SELECT PageID, UniqueKey, ResumeID,
 PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD,
 ChangeFreq_sitemap, PagePriority
 FROM SITEMAPU_Resume_ByFunction_Pages
 WHERE ResumeID = 51269 

 SELECT PageID, UniqueKey, ResumeID,
 PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD,
 ChangeFreq_sitemap, PagePriority
 FROM SITEMAPU_Resume_ByFunction_Pages
 WHERE ResumeID = 47418 

 SELECT PageID, UniqueKey, ResumeID,
 PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD,
 ChangeFreq_sitemap, PagePriority
 FROM SITEMAPU_Resume_ByFunction_Pages
 WHERE ResumeID = 35773 

 SELECT PageID, UniqueKey, ResumeID,
 PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD,
 ChangeFreq_sitemap, PagePriority
 FROM SITEMAPU_Resume_ByFunction_Pages
 WHERE ResumeID = 23359 

 SELECT PageID, UniqueKey, ResumeID,
 PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD,
 ChangeFreq_sitemap, PagePriority
 FROM SITEMAPU_Resume_ByFunction_Pages
 WHERE ResumeID = 1611 

 SELECT PageID, UniqueKey, ResumeID,
 PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD,
 ChangeFreq_sitemap, PagePriority
 FROM SITEMAPU_Resume_ByFunction_Pages
 WHERE ResumeID = 33966 

 SELECT PageID, UniqueKey, ResumeID,
 PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD,
 ChangeFreq_sitemap, PagePriority
 FROM SITEMAPU_Resume_ByFunction_Pages
 WHERE ResumeID = 45015 

 SELECT PageID, UniqueKey, ResumeID,
 PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD,
 ChangeFreq_sitemap, PagePriority
 FROM SITEMAPU_Resume_ByFunction_Pages
 WHERE ResumeID = 38538 

 SELECT PageID, UniqueKey, ResumeID,
 PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD,
 ChangeFreq_sitemap, PagePriority
 FROM SITEMAPU_Resume_ByFunction_Pages
 WHERE ResumeID = 72674 

 SELECT PageID, UniqueKey, ResumeID,
 PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD,
 ChangeFreq_sitemap, PagePriority
 FROM SITEMAPU_Resume_ByFunction_Pages
 WHERE ResumeID = 27681 

 SELECT PageID, UniqueKey, ResumeID,
 PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD,
 ChangeFreq_sitemap, PagePriority
 FROM SITEMAPU_Resume_ByFunction_Pages
 WHERE ResumeID = 26326 

 SELECT PageID, UniqueKey, ResumeID,
 PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD,
 ChangeFreq_sitemap, PagePriority
 FROM SITEMAPU_Resume_ByFunction_Pages
 WHERE ResumeID = 49301 

 SELECT PageID, UniqueKey, ResumeID,
 PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD,
 ChangeFreq_sitemap, PagePriority
 FROM SITEMAPU_Resume_ByFunction_Pages
 WHERE ResumeID = 26533 

SelectNamesByIDs (Datasource=ritesite, Time=0ms) in D:\inetpub\wwwroot\ritesite.com\gbl\spSelectNamesByIDs.cfm @ 17:21:28.028

	parameters type CFSQLType value variable dbVarName  IN  CF_SQL_INTEGER  NULL      IN  CF_SQL_CHAR  NULL      IN  CF_SQL_INTEGER  NULL      IN  CF_SQL_INTEGER  NULL      IN  CF_SQL_INTEGER  NULL      IN  CF_SQL_INTEGER  NULL
	resultsets name resultset  rsSelectNamesByIDs1  1  rsSelectNamesByIDs2  2  rsSelectNamesByIDs3  3  rsSelectNamesByIDs4  4  rsSelectNamesByIDs5  5  rsSelectNamesByIDs6  6

Application Variables: applicationname=RiteSite 

CGI Variables: AUTH_PASSWORD= AUTH_TYPE= AUTH_USER= CERT_COOKIE= CERT_FLAGS= CERT_ISSUER= CERT_KEYSIZE=128 CERT_SECRETKEYSIZE=2048 CERT_SERIALNUMBER= CERT_SERVER_ISSUER=C=US, O=DigiCert Inc, CN=DigiCert TLS RSA SHA256 2020 CA1 CERT_SERVER_SUBJECT=C=US, S=Louisiana, L=LaPlace, O=Ritesite Custom Career Services Inc, CN=www.ritesite.com CERT_SUBJECT= CF_TEMPLATE_PATH=D:\inetpub\wwwroot\ritesite.com\ResumeDatabase\SiteMapping_specific_index_By_Function.cfm CONTENT_LENGTH=0 CONTENT_TYPE= CONTEXT_PATH= GATEWAY_INTERFACE=CGI/1.1 HTTPS=on HTTPS_KEYSIZE=128 HTTPS_SECRETKEYSIZE=2048 HTTPS_SERVER_ISSUER=C=US, O=DigiCert Inc, CN=DigiCert TLS RSA SHA256 2020 CA1 HTTPS_SERVER_SUBJECT=C=US, S=Louisiana, L=LaPlace, O=Ritesite Custom Career Services Inc, CN=www.ritesite.com HTTP_ACCEPT= HTTP_ACCEPT_ENCODING=gzip,deflate HTTP_ACCEPT_LANGUAGE= HTTP_CONNECTION=close HTTP_COOKIE= HTTP_HOST=www.ritesite.com HTTP_REFERER= HTTP_URL= HTTP_USER_AGENT=ColdFusion LOCAL_ADDR=192.168.1.28 PATH_INFO= PATH_TRANSLATED=D:\inetpub\wwwroot\ritesite.com\ResumeDatabase\SiteMapping_specific_index_By_Function.cfm QUERY_STRING=page=enter&IndustryID=0&FunctionID=1022&geoPreference=1&city=&state=&region=&cityName=&stateName=&regionName=&compensation=&compensationName=&start=561&createfile=29&showhide=1&SiteMapFunctionName=Technology&SMGROUP_ID=35&RequestTimeout=999999 REMOTE_ADDR=192.168.1.49 REMOTE_HOST=192.168.1.49 REMOTE_USER= REQUEST_METHOD=GET SCRIPT_NAME=/ResumeDatabase/SiteMapping_specific_index_By_Function.cfm SERVER_NAME=www.ritesite.com SERVER_PORT=443 SERVER_PORT_SECURE=1 SERVER_PROTOCOL=HTTP/1.1 SERVER_SOFTWARE=Microsoft-IIS/8.5 WEB_SERVER_API= 

Cookie Variables: CFID=2037863 CFTOKEN=3813a5cee73ef2f4-7E0A0549-F235-7834-820B08351DBC3B8A 

Server Variables: coldfusion=Struct (10) os=Struct (5) 

Session Variables: cfid=2037863 cftoken=3813a5cee73ef2f4-7E0A0549-F235-7834-820B08351DBC3B8A jobrecon=0 reconwindowsame=1 resultsperpage=20 rsdirectonly=0 rsjava_ok=1 rswindowsame=1 sessionid=RITESITE_2037863_3813a5cee73ef2f4-7E0A0549-F235-7834-820B08351DBC3B8A urltoken=CFID=2037863&CFTOKEN=3813a5cee73ef2f4-7E0A0549-F235-7834-820B08351DBC3B8A 

URL Parameters: FunctionID=1022 IndustryID=0 RequestTimeout=999999 SMGROUP_ID=35 SiteMapFunctionName=Technology city= cityName= compensation= compensationName= createfile=29 geoPreference=1 page=enter region= regionName= showhide=1 start=561 state= stateName=