trapping script timeout errors

Is there a way to redirect to a custom error page if the script times out.
I have set the scripttimeout to 300 in both code and in iis but it still
times out too early, plus if the user is too vague in the search and it
times out i just wanna be able to tell them to refine their search

Re: trapping script timeout errors

Perhaps your query method is inefficient?


"Steven Scaife" wrote in message
news:eHpJQmrsEHA.2072@tk2msftngp13.phx.gbl...
> Is there a way to redirect to a custom error page if the script times out.
> I have set the scripttimeout to 300 in both code and in iis but it still
> times out too early, plus if the user is too vague in the search and it
> times out i just wanna be able to tell them to refine their search
>
>

Re: trapping script timeout errors

Uses a stored procedure that builds the sql string dynamically inside of it,
from a possible 50 search parameters. using a dsn-less connection in the
ASP page. Its a 70gig SQL 2000 database with over 3,500,000 customers and
grows daily. The searches are generally fast but there is the odd time when
the query takes too long.

What would you suggest to make it more efficient?

"dave" wrote in message
news:uWMMNsJtEHA.3324@TK2MSFTNGP15.phx.gbl...
> Perhaps your query method is inefficient?
>
>
> "Steven Scaife" wrote in message
> news:eHpJQmrsEHA.2072@tk2msftngp13.phx.gbl...
> > Is there a way to redirect to a custom error page if the script times
out.
> > I have set the scripttimeout to 300 in both code and in iis but it still
> > times out too early, plus if the user is too vague in the search and it
> > times out i just wanna be able to tell them to refine their search
> >
> >
>
>

Re: trapping script timeout errors

Determine which set of parameters causes it to run slowly* and optimize it,
perhaps setting up indexes for it to use when those parameters are sent.

Bob Barrows

*You can use SQL Profiler for this

Steven Scaife wrote:
> Uses a stored procedure that builds the sql string dynamically inside
> of it, from a possible 50 search parameters. using a dsn-less
> connection in the ASP page. Its a 70gig SQL 2000 database with over
> 3,500,000 customers and grows daily. The searches are generally fast
> but there is the odd time when the query takes too long.
>
> What would you suggest to make it more efficient?
>
> "dave" wrote in message
> news:uWMMNsJtEHA.3324@TK2MSFTNGP15.phx.gbl...
>> Perhaps your query method is inefficient?
>>
>>
>> "Steven Scaife" wrote in message
>> news:eHpJQmrsEHA.2072@tk2msftngp13.phx.gbl...
>>> Is there a way to redirect to a custom error page if the script
>>> times out. I have set the scripttimeout to 300 in both code and in
>>> iis but it still times out too early, plus if the user is too vague
>>> in the search and it times out i just wanna be able to tell them to
>>> refine their search

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.