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
