Page Time out for huge database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have a huge database which can only turn the result in minimum 2 minutes.
At out ASP.net Application
we modify the ado object timeout secound
but now we get the page time out from the System.Exeption
what we should modify more?
machine.config?
web.config?
ISS?

Thanks
 
Hi,

are you using Active Directory Domain Controllers ?

You can set the PageTimeout property of
Microsoft.SharePoint.Portal.UserProfiles.DomainController class to increase
the time the server should search for the page. Default is 120 seconds.

If it is anything else, let us know ?

Thanks
Joyjit
 
The best thing to modify would be the database - 2 minutes for each query -
being queried by an asp.net application is not ideal.

If you cannot do that, then I suggest coding up a facade layer that runs as
a service and an asp.net page that refreshes itself, shows a progress bar,
and uses this facade layer over a remoting interface for it's dataretreival
needs.

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik
 
Take a look at the httpRuntime entry in your machine.config file. This
controls how long the system will wait for responses to complete before
deciding that it should time them out. You may be able to override
these int he web.config file for your application, but I'm not positive
about that (some settings can be overridden some can not). Also take a
look at the various other timeout attributes throughout the file. Hope
this helps.

Have A Better One!

John M Deal, MCP
Necessity Software
 
Back
Top