Hello,
Currently there is a section of my webpage that generates a massive
list (Requing 400-800 queries per hit), that is taxing down my
server. These pages are dynamic, driven by a SQL DB, that doesnt
change all the time. CFCACHE wont work, since it also relies on
cookies.
My solution is to create the pages (360, varitions of view and
cookies), and store them into a Db table. And when someone requests
to see one, retreve the entire page from the DB and output it. So
each time a update takes place to the underlying tables, the pages
must be regenerated. Sometimes only a few, other changes could affect
all.
In the case were it affects all, I schedule an event to run Once,
after updating the DB, to regenerate all the pages (~15 min process).
Only, it doesnt run. It does work, if I go into the CFIDE and modify
the Task. Otherwise, it just ignores it.
This is what my code looks like:
<cfschedule Task="<TaskName>"
Action = "Update"
Operation = "HTTPRequest"
URL = "<URL>"
StartDate = "#DateFormat(Now())#"
StartTime = "#TimeFormat(DateAdd('n',10,Now()),'HH:mm:ss')#"
Interval = "Once"
EndDate = "#DateFormat(DateAdd('d',1,Now()))#"
EndTime = "#TimeFormat(DateAdd('n',30,Now()),'HH:mm:ss')#"
RequestTimeOut=900>
Any ideas? - I'm running NT4/CF4.5.1/MS SQL 7
Thanks,
David Scheiderich
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
