A better response to this is to fix the query or redefine the needed data so less is returned.
Other possible options, setting the timeout attribute on the cfquery tag If you absolutely have to run that query then tune the DB tables with indexes. It may also be possible your hardware for the DB server is under powered. Are you sure you really need to run that query the way you are? Is the data for a report? can the report be run on the DB side and put into a reporting table? This is just the beginning of the possibilities, what the heck are ya doing? Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. On Jan 15, 2009, at 7:11 PM, Craigsell wrote: > Need help with another shining example of my ignorance -- I'm more > of a developer than a webserver person. > > We are working on one of our CF webservers and noticed something > strange. A user was running a very long query which subsequently > displays on the browser (10+ minutes, tons of data - don't ask it's > a mess). It was chewing up huge amounts of memory and CPU. We > contacted the user and found that they had gotten tired of waiting > and quit the browser -- closed it right down. > > Adobe confirms that CF has no visibility into whether the socket is > still live. It just runs until it's done, then dumps the results > when it tries to display to the page and finds the socket is gone. > Adobe suggested we write some sort of servlet to monitor the sockets > and kill of the ones that are not valid. > > And that's where they lost me. Can anyone point me to some code for > the Java challenged that will do this or at least a better > explanation? > > Thanks! > > Warren Koch > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318043 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
