: : TVSpy Home

: : Log In

: : Member Home

: : Forget Password?

: : Change E-mail

: : FAQ & Contact Info

: : ShopTalk Subscription

FREE MEMBERSHIP

GOLD MEMBERSHIP

CORPORATE GOLD MEMBERSHIP

POST JOBS

ADVERTISE

February 09, 2010

NGTV Newsletter Archives older than the 4 most recent issues are now restricted to TVSpy Gold Members.

• NGTV Newsletter - 03/29/2005
• NGTV Newsletter - 03/16/2005

• NGTV Newsletter - 03/09/2005
• NGTV Newsletter - 03/02/2005

To view a complete list of NGTV Archives:

Already a Gold Member? Log into your TVSpy account first.

	Next Generation TV Home
	NGTV Watercooler
	Receive NGTV Newsletter Free
	NGTV Newsletter Archive
	Report Digital Media News
	Contact Us

Related Resources

	Contact Digital Media Executives
	Submit a TVSpy Directory Listing
	Search Digital Media Services
	Receive Shoptalk FREE
	Search Surveys on Digital Media Companies
	Submit an Employer Survey
	Gold Membership

	In Defense of Video Journalists (VJs) (December 06, 2005)
	Time to Retire the Anchor Desk? (November 30, 2005)
	Beyond TV (November 23, 2005)
	Let's Talk Video Blogging (Or Is It Vlogging?) (November 16, 2005)

NGTV Article Archive >>

Watercooler Admin | HN Admin | Sandbox Admin | NextGen Admin | NextGen Admin

Debugging Information

ColdFusion Server Enterprise	7,0,0,91690
Template	/nexttv/nexttv_archive_list.cfm
Time Stamp	09-Feb-10 08:52 AM
Locale	English (US)
User Agent	CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote IP	209.208.132.227
Host Name	209.208.132.227

Execution Time

Total Time	Avg Time	Count	Template
125 ms	125 ms	1	E:\Inetpub\wwwroot\tvspy\nexttv\nexttv_archive_list.cfm
16 ms	16 ms	1	E:\Inetpub\wwwroot\tvspy\nexttv\_nexttv_right.cfm
0 ms	0 ms	1	E:\Inetpub\wwwroot\tvspy\Application.cfm
0 ms	0 ms	1	E:\Inetpub\wwwroot\tvspy\_bottom.cfm
0 ms	0 ms	2	E:\Inetpub\wwwroot\tvspy\_google_include.cfm
0 ms	0 ms	1	E:\Inetpub\wwwroot\tvspy\_left.cfm
0 ms	0 ms	1	E:\Inetpub\wwwroot\tvspy\_top.cfm
0 ms	0 ms	1	E:\Inetpub\wwwroot\tvspy\ads\_adinclude-tiles.cfm
0 ms	0 ms	1	E:\Inetpub\wwwroot\tvspy\ads\_adincludetop.cfm
0 ms	0 ms	1	E:\Inetpub\wwwroot\tvspy\ads\_nytimes_258_static.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
125 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SQL Queries

nexttv_newsletterlist (Datasource=vault, Time=78ms, Records=4) in E:\Inetpub\wwwroot\tvspy\nexttv\nexttv_archive_list.cfm @ 08:52:32.032

select T_NEWSLETTERS_ID,datecreated
from  t_newsletters
where active = 0
and datecreated < to_date('02/09/2010','mm/dd/yyyy')
order by datecreated desc

getwatercooler (Datasource=vault, Time=0ms, Records=1, Cached Query) in E:\Inetpub\wwwroot\tvspy\nexttv\nexttv_archive_list.cfm @ 08:52:32.032

			SELECT TODAY spotlight,                         
			WATERCOOLER watercooler     
       	 from t_main
			where type=2

nexttvcolumns (Datasource=vault, Time=31ms, Records=4) in E:\Inetpub\wwwroot\tvspy\nexttv\nexttv_archive_list.cfm @ 08:52:32.032

 
select t_column_categories.t_content_cat_id,NEXTTV_TITLE,DATECREATED,t_nexttv.T_NEXTTV_ID
	from  t_nexttv,t_column_categories
	where t_column_categories.T_ID=t_nexttv.T_NEXTTV_ID
	and t_nexttv.active=1
	and t_column_categories.t_content_cat_id=10
	order by DATECREATED desc

Scope Variables

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=E:\Inetpub\wwwroot\tvspy\nexttv\nexttv_archive_list.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=text/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=CFID=62126296; CFTOKEN=74089522; JSESSIONID=9c30cd9f5a80$DB$F9$D; CFGLOBALS=urltoken%3DCFID%23%3D62126296%26CFTOKEN%23%3D74089522%23lastvisit%3D%7Bts%20%272010%2D02%2D09%2008%3A52%3A27%27%7D%23timecreated%3D%7Bts%20%272010%2D02%2D09%2008%3A48%3A15%27%7D%23hitcount%3D16%23cftoken%3D74089522%23cfid%3D62126296%23; NSC_uwtqz.dpn=ffffffffd2d89a0f45525d5f4f58455e445a4a423660
HTTP_HOST=www.tvspy.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/nexttv/nexttv_archive_list.cfm
PATH_TRANSLATED=E:\Inetpub\wwwroot\tvspy\nexttv\nexttv_archive_list.cfm
QUERY_STRING=
REMOTE_ADDR=209.208.132.227
REMOTE_HOST=209.208.132.227
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/nexttv/nexttv_archive_list.cfm
SERVER_NAME=www.tvspy.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=

Client Variables:
cfid=62126296
cftoken=74089522
hitcount=16
lastvisit={ts '2010-02-09 08:52:27'}
timecreated={ts '2010-02-09 08:48:15'}
urltoken=CFID=62126296&CFTOKEN=74089522

Cookie Variables:
CFGLOBALS=urltoken=CFID#=62126296&CFTOKEN#=74089522#lastvisit={ts '2010-02-09 08:52:27'}#timecreated={ts '2010-02-09 08:48:15'}#hitcount=16#cftoken=74089522#cfid=62126296#
CFID=62126296
CFTOKEN=74089522
JSESSIONID=9c30cd9f5a80$DB$F9$D
NSC_uwtqz.dpn=ffffffffd2d89a0f45525d5f4f58455e445a4a423660

Session Variables:
cfid=62126296
cftoken=74089522
destination=/shoptalk_archive_list.cfm?
premiumstatus=0
sessionid=TVSPYNEW_62126296_74089522
urltoken=CFID=62126296&CFTOKEN=74089522

Debug Rendering Time: 46 ms