how about adding WITH (NOLOCK) If your queries are just selecting data, i'd use WITH (NOLOCK)
that way you don't need to wait for transactions to finish if that table gets heavy inserts <cfquery name="test" datasource="dsn" timeout="1"> > select top 20000 * WITH (NOLOCK) > from table > </cfquery> On Tue, Apr 14, 2009 at 4:58 PM, Sung Woo <s...@cornell.edu> wrote: > > Actually, I was wrong -- even <cfsetting requesttimeout="1" > enablecfoutputonly="No"> doesn't work, because it still waits for the > cfquery to finish before it outputs the timeout error. Is there any > solution for this? The database we're relying on is unstable and we need to > be able to kill the query sooner. > > Thanks, > > - Sung > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:321591 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
