Avoid Timeouts

[SpagettiProg]

Hello All,

Other than setting my executionTimeout to 300 and maxRequestLength to 204800. Is there anything else I can do to avoid timeout issues.

Below is what I added to my webconfig file.......

<httpRuntime
executionTimeout="300"
maxRequestLength="204800"
useFullyQualifiedRedirectUrl="false"
minFreeThreads="8"
minLocalRequestFreeThreads="4"
appRequestQueueLimit="100"
/><!-- end of April 29 added code-->


Basically it only happens when I do a sql query that returns alot of results.
I'm not concerned about the sql side, as I'm trying to see what I can optimize
on the asp side. We have a sql guy to take care of that.

Any thoughts, help is appreciated.

[dj4uk]

Would it make sense to implement some kind of paging so you don't need to return so many records to the browser?

DJ

[SpagettiProg]

Would it make sense to implement some kind of paging so you don't need to return so many records to the browser?

DJ

Thanks, I was trying to avoid the paging (lazyness on my part), but it is good practice.

Thanks again, I will go with paging