I am trying to timeouts queries that run to long. I have set the timeout parameter of the cfquery tag at 10 seconds. I have tested the parameter with a long running loop and it fired..the query timed out. so I implemented the timeout parameter in certain places. A couple of days later while checking my log files I find entries saying that a particular page ran past the 60 second time warning, and this page has the query timeout value set at 10 seconds and I have a site wide 20 second timeout set for pages which I handle with a custom error page. I do see that in the advanced settings of the datasource there is a 600 millisecond timeout set. which is where, I guess, the 60 second timeout warning comes from. However this parameter of the datasource appeared to be overridden by the parameter of the cfquery tag in testing.
does anyome know why I am not able to time out these pages? which has Precedence the parameter of the query tag or the datasource setting? Why would the timeout value of the cfquery tag be ingnored? Thanks. Ron ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188810 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
