A transaction that has rolled back due to a deadlock should always be retried at least once. Unless your server is chronically ill or you use massively long transactions, the chances of getting the same deadlock twice in a row are pretty small.
Jaime > -----Original Message----- > From: [email protected] [mailto:[email protected]] > Sent: Friday, 3 April 2009 6:06 AM > To: cf-talk > Subject: RE: Query Retries > > > 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:321268 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
