Dramatically Increased Page Load time 2

[Nevermoor]

Hi,

I am currently attempting to debug a website which was initally developed as an intranet application on a MS 2000 Server and was recently moved to the internet on a MS 2003 box. The new server has a slower connection to the DB server (SQL Server 2000).

One of the most complicated pages has experienced a dramatic load time increase, it used to take ~2-4 seconds of server time and now takes ~45-120 seconds.

The page pulls values and calculation rules from seperate databases and then presents the finished calculations in a table, it can be accessed by going to

http://www.sfgreenprint.org,

clicking enter as guest, clicking "List all projects", clicking on "Tst 1" and then clicking on the Environmental Scorecard Link.

Thanks in advance for any suggestions.

 

[theniteowl]

Do you know what version of IIS was running on the old server?
In IIS 5 method calls carry a pretty big performance hit whereas in previous versions it was often the better way to go with script design to avoid performance issues.

Here is an Microsoft link on performance tuning.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnasp/html/asptips.asp

Is it possible that the server load on the 2003 box is higher so things run slower?



Paranoid? ME?? WHO WANTS TO KNOW????

 

[DotNetGnat]

Take a look at this

-DNG

 

[Nevermoor]

Thanks, I'll take a look at those and see if they do it.

As far as server load, it shouldn't be an issue since none of the sites hosted get many hits.

 

[theniteowl]

In our environment they often host virtual servers on the same box so the processor time gets divied up.


Paranoid? ME?? WHO WANTS TO KNOW????

 

[Nevermoor]

Turns out the problem was that I wasn't using disconnected Recordsets (I thought the Static flag was enough but apparently not). Load times are now <1second instead of >1minute.

http://www.4guysfromrolla.com/webtech/080101-1.shtml

If anyone has the same issue

Thanks all for the input!