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:
Hi,

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
Posted
Comments
[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

   
Comments
[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