RE: Scheduled Task Priority
> Do tasks run from the cf scheduler (CF5) run at a different > priority than those called via a browser? I wouldn't think > there would be a difference, since the CF scheduler just > thinks it's making an HTTP request, but... No, they don't run at a different priority. However, they do keep two CF threads busy at once, rather than just one, I think. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Scheduled Task Priority
- Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, August 01, 2003 1:29 PM Subject: RE: Scheduled Task Priority > > Do tasks run from the cf scheduler (CF5) run at a different > > priority than those called via a browser? I wouldn't think > > there would be a difference, since the CF scheduler just > > thinks it's making an HTTP request, but... > > No, they don't run at a different priority. However, they do keep two CF > threads busy at once, rather than just one, I think. 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. ~| 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
Re: Scheduled Task Priority
No. Of course, there may be something in Java to do this but up till now, the answer as far as I know is no. > 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. > > ~| 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
Re: Scheduled Task Priority
No. They're just CFHTTP calls to the url in question and work as any other http call to the same location. Personally, I hate the use of CFHTTP to implement scheduling and will have a full writeup on it to go to the MM wish list very soon. An internal call to the template in question is much more efficient. > Do tasks run from the cf scheduler (CF5) run at a different priority than those > called via a browser? I wouldn't think there would be a difference, since the > CF schedulere just thinks it's making an HTTP request, but... > > ~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Scheduled Task Priority
> 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. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Scheduled Task Priority
Yeah, I second that notion of moving non-Web page related stuff to another scripting language. We use PHP and cron here to handle some scheduled downloads and it works like a charm. Plus PHP (and Perl, for that matter) have OO features now that can make them much easier to learn. M -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 4:26 PM To: CF-Talk Subject: RE: Scheduled Task Priority > 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. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| 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
Re: Scheduled Task Priority
Alternately, try Python - it's a very powerful language that's equally easy to learn. I was writing functional programs in it (read: not "Hello World" or looping from 1 to n) in a couple of hours. It's syntax is very clean (cleaner than Perl and PHP), and you can invoke and test all sorts of scripts and modules and various ideas through an interactive prompt. And, if you turn into a real Python jockey, you can quickly segue into Jython, in which you can write Java classes in Python and invoke them in CF. All sorts of fun... Ok, well, fun if you're a programmer :) - Jim Haggerty, Mike wrote: >Yeah, I second that notion of moving non-Web page related stuff to >another scripting language. We use PHP and cron here to handle some >scheduled downloads and it works like a charm. Plus PHP (and Perl, for >that matter) have OO features now that can make them much easier to >learn. > >M > >-Original Message- >From: Dave Watts [mailto:[EMAIL PROTECTED] >Sent: Friday, August 01, 2003 4:26 PM >To: CF-Talk >Subject: RE: Scheduled Task Priority > > > > >>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. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 >fax: (202) 797-5444 > > ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Scheduled Task Priority
> > 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
Re: Scheduled Task Priority
I would suspect there is some CPU power and time consumed when moving 1 million records from one MySQL table to another. That kind of work is asking a bit much of ColdFusion which is intended to deliver web pages. Back end operations of that scope should be addressed in the MySQL control center as opposed to ColdFusion, I would surmise. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 == If you are not satisfied with my service, my job isn't done! - Original Message - From: "Jim McAtee" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, August 01, 2003 9:33 PM Subject: Re: Scheduled Task Priority | > > 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
RE: Scheduled Task Priority
JMS Queue! I've got a bunch of enhancement requests in on this...ability to specify number of threads for one thing... Stace -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 4:05 PM To: CF-Talk Subject: Re: Scheduled Task Priority No. Of course, there may be something in Java to do this but up till now, the answer as far as I know is no. > 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. > > ~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Scheduled Task Priority
> > > Is there a means of selectively killing a CF template that > > > was run via the scheduler? > > > ... > > > > No, I don't think you can do that. I'd recommend that you > > consider rewriting the script in something other than CF. > > ... > > Thanks. I'm not sure that would do much. It would let you selectively kill the process. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4