Just speaking for myself here-- I never retry a query. Most errors I tend to get with a database call is due to something like a column not existing or some data truncation error that is going to happen no matter how many times I try it.
The only times I have ever really seen SQL Server throw an error that is recoverable is when it is trying to to connect to some remote linked server via ODBC and the connection has timed out. In those specific instances, the query always works the second time. Why don't you tell us what kind of errors you usually have thrown from the database. ~Brad -------- Original Message -------- Subject: Query Retries From: Byte Me <[email protected]> Date: Thu, April 02, 2009 3:46 pm To: cf-talk <[email protected]> Is there a rule of thumb on how many times a query should be retried? I'm using nested cftry/catch and will retry a maximum of 4 times. Each retry is delayed by a random number of milliseconds. Thanks for any insight. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:321260 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
