timeout - ProcessRequest

[Guest]

I am having problems with a web form timing out. I have several text boxes
where the user can enter data to search by and a datagrid to display the
results. The problem is half of the time the search times out. I have
indexes on the search fields and some of the searches that timeout only
return one record. I have talked to our Network Admin and he ran an
analysis tool and says that the query is executing in milliseconds but when
it runs the ProcessRequest process to serve the page back to the browser it
takes forever and the page times out.

Does anyone have any ideas what could be causing this or anything I could
try??

thank
Kurt

 

[Guest]

Kurt,
if the database query is running in milliseconds then you have some other
issue going on. Can you post a "short but complete" code sample?

Why don't you set up some test code that completely bypasses the database
and just returns some "hard coded" result for testing purposes. Also, you can
temporarily turn on page tracing and with some Trace.Write's get a better
idea exactly where the bottleneck lies.

Peter