Thanks for clarifying.
So by "recoverable," do you mean a problem where the server is temporarily
unavailable? If that's the case, eeek. That's a bad situation to be in.
Generally, it just doesn't happen, so this isn't a problem you typically
have to solve.
What you may want to consider in this
> Is there a rule of thumb on how many times a query should be retried?
Thank you for the info everyone. I'm using Mysql and I'm not getting any
errors, I'm just trying to use good programming practices so the end user will
not see any error messages, in the event that a recoverable error is g
Hah, that's cool. I'd say it depends on how long you expect your database to
be down for, what DBMS you're using, how important the data is, how long the
user will wait for their data, and so on and so on. In other words, it
depends.
Generally speaking, you should never have to retry a query. It
rom: b...@bradwood.com [mailto:b...@bradwood.com]
> 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 co
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
I wouldn't say there is a rule of thumb for this, if your Query is failing
more than 4 times, and it happens often enough for you to need to think
about this, then I think you need to stop look at how to deal with and look
for ways to fix it.
Why is it that your running into this problem? I can't
Why are your queries failing?
On Thu, Apr 2, 2009 at 4:46 PM, Byte Me wrote:
>
> 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 i
7 matches
Mail list logo