Debugging Information
| ColdFusion Server Standard |
7,0,2,142559 |
| Template |
/ePreferreds/_scheduled/generateDividendAnnouncement.cfm |
| Time Stamp |
02-Jul-09 03:10 AM |
| Locale |
English (US) |
| User Agent |
CFSCHEDULE |
| Remote IP |
208.112.47.49 |
| Host Name |
208.112.47.49 |
Execution Time
| Total Time |
Avg Time |
Count |
Template |
| 78 ms |
78 ms |
1 |
D:\internet\webroot\ePreferreds\_scheduled\generateDividendAnnouncement.cfm |
| 31 ms |
31 ms |
1 |
D:\internet\webroot\ePreferreds\Application.cfm |
| 0 ms |
0 ms |
1 |
D:\internet\webroot\ePreferreds\include\staticDefinitions.cfm |
| 0 ms | |
STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN |
| 109 ms | |
TOTAL EXECUTION TIME |
red = over 250 ms average execution time
SQL Queries
getAnnouncement (Datasource=ePreferreds, Time=0ms, Records=22) in D:\internet\webroot\ePreferreds\_scheduled\generateDividendAnnouncement.cfm @ 03:10:00.000
SELECT
cusip,
ticker,
dividendAmount_rate,
dividendAmount_rate_prev,
description,
exDividendDate,
paymentTypeCode
FROM SecurityData SD WITH (NOLOCK)
WHERE
status = 1
AND ticker <> ''
AND exDividendDate > GETDATE()
AND paymentDate > lastPaymentDate
AND (dividendAmount_rate > 0 OR paymentTypeCode = '030')
AND exchange <> ' 7'
ORDER BY
fileDate DESC,
ticker
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=D:\internet\webroot\ePreferreds\_scheduled\generateDividendAnnouncement.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=yieldandincome.com
HTTP_REFERER=
HTTP_USER_AGENT=CFSCHEDULE
PATH_INFO=/ePreferreds/_scheduled/generateDividendAnnouncement.cfm
PATH_TRANSLATED=D:\internet\webroot\ePreferreds\_scheduled\generateDividendAnnouncement.cfm
QUERY_STRING=
REMOTE_ADDR=208.112.47.49
REMOTE_HOST=208.112.47.49
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/ePreferreds/_scheduled/generateDividendAnnouncement.cfm
SERVER_NAME=yieldandincome.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=1380399
cftoken=22749214
hitcount=1
lastvisit={ts '2009-07-02 03:10:00'}
timecreated={ts '2009-07-02 03:10:00'}
urltoken=CFID=1380399&CFTOKEN=22749214
Cookie Variables:
CFID=1380399
CFTOKEN=22749214
Session Variables:
cfid=1380399
cftoken=22749214
sessionid=EPREFERREDS_1380399_22749214
urltoken=CFID=1380399&CFTOKEN=22749214
Debug Rendering Time: 47 ms
|