All:
I'm working on a system that will have a large number of timed, one-time tasks that need to be executed on a schedule. I'm trying to figure out the best way to accomplish this with cfschedule. The two options I see are as follows: 1. A single, recurring task that runs every 5 minutes and queries the database for any tasks that need to be executed. The benefit of this approach is that there is only a single task to create. The negatives of this approach are (a) potentially querying the database when there are no tasks to execute (waste of resources) and (b) risk of too many tasks at any given time causing the scheduled execution to time out or cause later tasks in the run to be executed so late as to be off schedule. 2. Create a new cfschedule task for each task that needs to be run. The benefits of this approach are that it solves all of the negatives of the other approach. The negatives are that it would necessitate the creation of a very large number of cfschedule events and I don't know if this could negatively affect the scheduler or CF performance. Either approach would include code to do cleanup (e.g., delete the task from the CF scheduler after it has been executed, etc.). Any thoughts as to which approach (or a different one altogether) is better? Thanks in advance. -- Mosh Teitelbaum evoch, LLC ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345014 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
