Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 Slow load of Default.asp
 New Topic  Topic Locked
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

MarioLanning
New Member

USA
50 Posts

Posted - 30 May 2002 :  11:20:39  Show Profile  Visit MarioLanning's Homepage  Send MarioLanning an AOL message
So since the total time was 20 MS am I to assume its a problem with my web server or the actual asp files themselves?

Thanks a bunch :-)

Mario
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 30 May 2002 :  12:01:53  Show Profile  Send ruirib a Yahoo! Message
quote:

So since the total time was 20 MS am I to assume its a problem with my web server or the actual asp files themselves?


Yeah, I would say that it looks like that, indeed. Having those 4.x seconds page generation time, coupled with this, would point towards the Web server, quite likely.

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Go to Top of Page

MarioLanning
New Member

USA
50 Posts

Posted - 31 May 2002 :  23:47:33  Show Profile  Visit MarioLanning's Homepage  Send MarioLanning an AOL message
I just don't get it. I moved it to a new poweredge server all by itself with dual 1.3 Ghz Processors and 1 GB ram. I tried the form before I even added any other sites to that server. Still the same thing. URGH.. Ok.. I give up.. I have one more thing I'm adding to the network next week and we shal see. foundrynetworks fastiron switch.. If all this does not fix it I'll scream!

http://widescreenhd.tv
Go to Top of Page

Aaron S.
Average Member

USA
985 Posts

Posted - 01 June 2002 :  00:03:14  Show Profile  Visit Aaron S.'s Homepage
I have had DB calls take a few MSs but the page takes 4+ seconds to load.

I fixed a lot of it by reducing calls to the recordset (using getrows) and consolidatin DB calls.

jump_to.asp is a very slow page. It is an inlcude on active.asp and topic.asp. By changing the file... I cut down the page load time by 50%+.

--Aaron



DOWNLOAD GREAT NEW MODS HERE
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 01 June 2002 :  06:34:19  Show Profile  Send ruirib a Yahoo! Message
There is something weird there Mario. Unless this Snitz version is already optimized (and I do admit that is possible, but maybe Richard or Huw can confirm), I get a 1.6 secs page generation time for default.asp at this forum and your forum does not have
neither the number of users nor the number of categories/forums as this one.

Is your Web server on the same machine as the SQL Server?

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs


Edited by - ruirib on 01 June 2002 06:38:00
Go to Top of Page

MarioLanning
New Member

USA
50 Posts

Posted - 02 June 2002 :  10:12:16  Show Profile  Visit MarioLanning's Homepage  Send MarioLanning an AOL message
No ruirib, the SQL server is another machine, its no slug either. Its a clustered set of maxed out poweredges. Last night I added the second SQL server becauuse it did need to be upgraded as you can see from my previous post. I first thought it was the servers but the CPU's are nowhere near being overloaded anymore. I tried perfmon out and loading the page. Its not a CPU issue.

Aaron. could you mail me the modified ASP pages you made so I may try them out on my server to see if that can correct it?

me@myserver.org

http://widescreenhd.tv
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 02 June 2002 :  14:34:10  Show Profile  Send ruirib a Yahoo! Message
quote:

No ruirib, the SQL server is another machine, its no slug either.


Well how fast is the network response? Those performance tests you made were they done from the Web server machine or directly on the SQL Server computer?

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Go to Top of Page

scottw
Starting Member

USA
3 Posts

Posted - 14 August 2002 :  12:42:47  Show Profile  Visit scottw's Homepage  Send scottw an ICQ Message
I too had real slow loading of my default page. Also many other pages. One solution I found was to cache the .INC files in the web server. This cut down the load time of my default page by over 50%.

Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.13 seconds. Powered By: Snitz Forums 2000 Version 3.4.07