Click here to Skip to main content
14,733,333 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

I am working on an application.

I am collecting the inputs from user i Asp .Net form and then querying the database(on another server).From the output, I create a report and send it back to the user.

The problem is , database query takes a lot of time (approx 2 min).By that time, the request times out.

How to set the time out for the request so that the user can get back the response ?

I tried many ways in web config

<httpRuntime maxRequestLength="104857600" executionTimeout="360000" />

<sessionState mode="InProc" timeout="90"></sessionState>

 <requestLimits maxAllowedContentLength="2000000000000" />

But i didnt get out put
[no name] 21-Jan-15 3:53am
If your database query takes more time try to optimize the query so that there will not be any timeout. If you want us to optimize the query as well you need to post the query as well.
[no name] 21-Jan-15 5:47am
thanks patro i will try to optimize my query

1 solution

[no name] 21-Jan-15 4:39am
I try above things eventhough i didnt get
deepankarbhatnagar 21-Jan-15 7:49am
try to find ant session.abandon in any of your page.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900