Battle of the Titans

Total Time	Avg Time	Count	Template
150 ms	150 ms	1	/home/ccvbuser/public_html/calendar/event_detail2.cfm
107 ms	107 ms	1	/home/ccvbuser/public_html/common/masterfooter.cfm
22 ms	22 ms	1	/home/ccvbuser/public_html/common/masterheader.cfm
22 ms	22 ms	1	/home/ccvbuser/public_html/common/sidenav.cfm
4 ms	4 ms	1	/home/ccvbuser/public_html/calendar/Application.cfm
2 ms	2 ms	1	/home/ccvbuser/public_html/Application.cfm
0 ms	0 ms	1	/home/ccvbuser/public_html/language_english.cfm
2 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
156 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

      SELECT e.EventID,
             e.EventName,
             e.StartDateTime,
             e.EndDateTime,
             et.EventType,
						 et.EventTypeID,
             e.EventShortDesc,
             e.EventDescription,
             e.Location,
             e.EventURL,
						 e.logo,
             e.EventImage,
             e.EventImage2,
             e.EventImage3,
             e.EventImage4,
             e.EventImage5,
             e.ContactName,
             e.ContactPhone,
             e.ContactEmail,
             e.AllDayFlag,
						 e.active
        FROM cal_event e, cal_event_type et
       WHERE e.EventTypeID = et.EventTypeID
         AND e.EventID = 1143
				 AND e.active = 1
       ORDER BY e.StartDateTime
      

					SELECT e.EventID, 
								 e.EventName, 
								 e.StartDateTime,	 
								 e.EndDateTime, 
								 e.EventShortDesc, 
								 e.Location, 
								 e.active, 
								 e.signature_event, 
								 e.EventImage, et.EventType
						FROM cal_event e INNER JOIN cal_event_type et ON e.EventTypeID = et.EventTypeID
					 WHERE active = 1 
					 	 AND (Month(e.StartDateTime) = 4 OR Month(e.EndDateTime) = 4)
						  AND (Year(e.StartDateTime) = 2008 OR Year(e.EndDateTime) = 2008)
					 ORDER BY e.StartDateTime
					

			SELECT *
				FROM subcat sc INNER JOIN category c ON sc.catid=c.catid
			 WHERE c.catid = 1 AND activity_type <> 'Mountain'
				
		ORDER BY activity_type DESC, subcat
		

			SELECT *
				FROM subcat sc INNER JOIN category c ON sc.catid=c.catid
			 WHERE c.catid = 1 AND activity_type = 'Mountain'
				
		ORDER BY activity_type DESC, subcat
		

			SELECT *
				FROM subcat sc INNER JOIN category c ON sc.catid=c.catid
			 WHERE c.catid = 2
				
		ORDER BY activity_type DESC, subcat
		

			SELECT *
				FROM subcat sc INNER JOIN category c ON sc.catid=c.catid
			 WHERE c.catid = 6
				
		ORDER BY activity_type DESC, subcat
		

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=/home/ccvbuser/public_html/calendar/event_detail2.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=Accept: application/xhtml+xml,text/html;q=0.9,text/plain;
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.headwatersofadventure.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=
PATH_TRANSLATED=/home/ccvbuser/public_html/calendar/event_detail2.cfm
QUERY_STRING=EventId=1143&Month=4&Year=2008
REMOTE_ADDR=38.103.63.56
REMOTE_HOST=38.103.63.56
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/calendar/event_detail2.cfm
SERVER_NAME=www.headwatersofadventure.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache/1.3.41 (Unix) JRun/4.0 PHP/4.4.6 mod_log_bytes/1.2 mod_bwlimited/1.4 mod_auth_passthrough/1.8 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.7a
WEB_SERVER_API=

Cookie Variables:
CFGLOBALS=urltoken=CFID#=8615488&CFTOKEN#=98113284#lastvisit={ts '2008-12-03 19:31:28'}#timecreated={ts '2008-12-03 19:31:28'}#hitcount=2#cftoken=98113284#cfid=8615488#
CFID=8615488
CFTOKEN=98113284
LANGUAGE=english

Session Variables:
adminflag=false
cfid=8615488
cftoken=98113284
emailaddress=
initialized=true
lastlogin=
loggedinflag=false
name=
sessionid=APPS_8615488_98113284
urltoken=CFID=8615488&CFTOKEN=98113284
userid=

URL Parameters:
EVENTID=1143
MONTH=4
YEAR=2008