How long does the query take to execute outside of asp.net? (like from
Query Analyzer).
If the query is taking 5 minutes to execute you'll need to figure out
why. Does it try to return 10 million records?
If it takes a long time to return just 5 records, perhaps it needs an
index:
http://odetocode.com/Articles/237.aspx
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Thu, 24 Mar 2005 16:09:50 +0100, "simon"
<si*********@stud-moderna.si> wrote:
I have ASP.NET application.
This application performs very well for 99% of the time
but occasionally I get the following error message:
The timeout period elapsed prior to completion of the operation or the
server is not responding
The proc that is executing is doing a SELECT only.
How can I solve this problem?
Thank you,
Simon