> > Is there a means of selectively killing a CF template that > > was run via the scheduler? Without cycling the CF service > > itself, that is? It's got a _very_ long RequestTimeout, yet > > looks like it won't be able to complete in that time. I'm > > surprised it hasn't taken the CF server down, so it must > > be the DB server that's the bottleneck. > > No, I don't think you can do that. I'd recommend that you consider rewriting > the script in something other than CF. While it's easy to use CF for > non-runtime tasks, and sometimes necessary, it makes sense to offload those > sorts of things from CF wherever possible, since it may impact the > performance of other scripts run by users.
Thanks. I'm not sure that would do much. The script is running on a development server, so only affects the other developers on our staff. Like I say, the CF server still seems to function well, as the bottleneck appears to be with the database operations. This particular script is crunching data from a 5 million record MySQL table into another that should be maybe 1/20th the size. I'd just like to kill it and start over with a better plan of attack. I thought I'd figured it out, but apparently, by the speed at which the script is executing, I've overlooked something. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
