Re: cfquery timeout doesn't work out on jdbc driver
Or figure out why its running slowly, and make it run faster. =) Rick On Thu, Oct 8, 2009 at 12:01 PM, Adam Haskell wrote: > > Run it in a thread with CFthread and put a timeout on the cfjoin. > > Adam > > > On Thu, Oct 8, 2009 at 8:47 AM, Vamsi Pappu wrote: > >> >> Hi All, >> >> I have a situation here where cfquery doesn't seem to be performing well on >> jdbc driver, when I read in forums it was clearly mentioned that cfquery >> timeout doesn't support some drivers, Is there any another alternate to >> this. >> >> My requirement is no matter what happens, if query is not responding in >> given amount of time then it should timeout.Can anyone suggest a good >> advice. >> >> Thanks, >> Vamsi >> >> > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327052 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery timeout doesn't work out on jdbc driver
Run it in a thread with CFthread and put a timeout on the cfjoin. Adam On Thu, Oct 8, 2009 at 8:47 AM, Vamsi Pappu wrote: > > Hi All, > > I have a situation here where cfquery doesn't seem to be performing well on > jdbc driver, when I read in forums it was clearly mentioned that cfquery > timeout doesn't support some drivers, Is there any another alternate to > this. > > My requirement is no matter what happens, if query is not responding in > given amount of time then it should timeout.Can anyone suggest a good > advice. > > Thanks, > Vamsi > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327036 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfquery timeout doesn't work out on jdbc driver
How about installing SeeFusion and enabling one of its rules to kill threads that run for a certain about of time? If there is a running query it will kill it. It may be a hammer where you wanted a scalpel, but it would work. Since requests who area waiting for external I/O can't monitor themselves, often the only way to ensure such a timeout is with a second monitor thread. ~Brad Original Message Subject: cfquery timeout doesn't work out on jdbc driver From: Vamsi Pappu Date: Thu, October 08, 2009 7:47 am To: cf-talk My requirement is no matter what happens, if query is not responding in given amount of time then it should timeout.Can anyone suggest a good advice. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327034 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfquery timeout doesn't work out on jdbc driver
Hi All, I have a situation here where cfquery doesn't seem to be performing well on jdbc driver, when I read in forums it was clearly mentioned that cfquery timeout doesn't support some drivers, Is there any another alternate to this. My requirement is no matter what happens, if query is not responding in given amount of time then it should timeout.Can anyone suggest a good advice. Thanks, Vamsi ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327028 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4