Here's my test:
<cfquery name="test" datasource="dsn" timeout="1">
select top 20000 *
from table
</cfquery>
<cfoutput>#cfquery.ExecutionTime#</cfoutput>
I'm getting 3000+ for this value. This shouldn't be, right? Because I have
the timeout parameter set for a second? The driver I'm using is the one that's
supplied with CFMX7.02, "Microsoft SQL Server".
The only way I can make this work is if I use <cfsetting requesttimeout="1"
enablecfoutputonly="No">, but I don't want to do that. What is going on?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:321579
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
