Slow Default.asp load time
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=6693
Printed Date: 03 April 2026 at 11:14pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Slow Default.asp load time
Posted By: PrimeraRacer
Subject: Slow Default.asp load time
Date Posted: 24 October 2003 at 4:25pm
|
ayup, just wanted to throw this down on the table and see if there is any way to speed it up. the default.asp page on the forum always takes longer to load. in a perfect scenario when a user is logged in we get about 4.2 seconds which is bearable. where you are not logged in the load time jumps up to about 20 seconds. also, all the other forum pages are super quick and its definately not a problem with the host as this is the same on two different hosts and we have just upgraded to a dedicated server now. also it happened when the forum was bog standard too straight out of the box. I just want to know why it takes much longer to load that page and what can be done to speed up the load time. the system is SQL and the forum address is http://www.npoc.co.uk/forum - http://www.npoc.co.uk/forum this IS a confirmed issue with the code on default.asp.... just want to know what can be changed to speed it up! many thanks, hope we can find something!! Kev |
Replies:
Posted By: PrimeraRacer
Date Posted: 24 October 2003 at 4:26pm
|
ooh actually just wanted to throw in my thought on it. I'm sure its something to do with the way it connects to SQL.... is there a faster SQL connection that can be made to the server at all? |
Posted By: God_Struth
Date Posted: 24 October 2003 at 9:45pm
If its a 'confirmed issue' then surely you would know whats wrong and would merely be seeking help on how to ammend it, if you don't know then it cannot be a 'confirmed issue'. Post what results you got that came to the conclusion that this is indeed a problem. I also use SQL version and would love to know what speed issues you have found. ------------- "I'm only trying to help......" |
PrimeraRacer wrote:Posted By: ljamal
Date Posted: 24 October 2003 at 11:46pm
|
Are your SQL server and web server on the same network? The load problem you are experiencing is caused by the multiple calls to the database. With version 7.01, the default page makes 3-4 calls to the SQL Server per forum in the database. Each call takes maybe .5 seconds, but when you have 10-20 forums, it begins to add up. I first noticed this problem when I went live with the forums as my SQL server is local to my development server but it's 3 time zones away from my live server and pages that took 2 seconds to generate on the development server were taking 15-20 seconds on the live server.
The solution for me was to rewrite the code for the most accessed pages so that all the information could be returned from one call to the SQL Server. I would love to sit down and implement it through the forum, but it would take a major rewrite of the code as the code for the forum does not use SQL Server to its maximum potential. This forum is really written for Access and that's the main reason that the SQL Server code is poorly implemented. My suggestion, if you don't have a large forum is to which to Access. Otherwise, to speed up the pages you will need to rewrite the SQL calls for the slow pages. ------------- L. Jamal Walton http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming |
Posted By: PrimeraRacer
Date Posted: 25 October 2003 at 5:33am
|
I knew I would get someone answer like this. if you read the post properly you would see I put "issue" not problem. its confirmed because it slows down when your not logged in, hence its not an ISP thing....also it only happens on the defautl page and no others. perhaps you could just help me try and improve it rather than try and instantly throw it back on me.... the guy after you seems to be helping, why not try and be more like him eh! |
Posted By: PrimeraRacer
Date Posted: 25 October 2003 at 5:35am
|
many thanks. Its really only the default page that slow, I figured it would be calls to the SQL server or somethign slowing it dow, we do indeed have quite a few forums. I'm no expert when it comes to writing calls to an SQL server but any help you can give on getting just that page sorted would be a great help!!! Thanks again |
Posted By: ljamal
Date Posted: 25 October 2003 at 9:02am
|
Without physical rewriting the page for you, there is not much help to be given.
Currently for the default page, WWF makes: 1 hit to check the database configuration 4 if you are logged in and have private messages turned on. 2 if PMs are turned off. 3 More if you have active messages turned on. 1 for All Categories 1 for each category to return the forums 1 for each forum to get forum permissions 1 for each forum to get the forum group Moderators (if moderators are displayed) 1 for each forum to get the forum user Moderators (if moderators are displayed) 1 for each forum to get the last post date 1 call to get the last registered user 2 calls to get the active users and guests If you have 1 forum and everything turned on that's 17 hits to the database. That's the bare minimum hits to the database if you have forums and it increase from there. I would love to consult with -borg- to correct this problem for SQL and suggest methods for improving the forum, but it would take a entire rewrite of the current code and I don't think he would be interested in something like that right now. When I have time, I was planning on releasing a SQL optimized version of the code, but I have 4 projects i n production at this point. Maybe in the future, I'll have time to talk with -borg- about this. ------------- L. Jamal Walton http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming |
Posted By: fernan82
Date Posted: 25 October 2003 at 9:40am
|
Here's some things you can do:
1. Get rid of the nav bar with the active users on top, that's a list 1 hit to the db depending how it's done. 2. Get rid of the member birthdays thing you got, that's at least one more hit. 3. Get rid of the latest posts at the bottom, that's at least one more hit and if you used the mod posted here that checks the permissions then it's one more hit for each latest topic 13 xtra hit's in your case. It can be done with just one tho, but the mod uses all that... 4. Disable active users. If I remember right WWF uses 2 or 3 hits to the db to get that simple count... Plus 3 more hits on active_users_inc.asp. After you get rid of all that you should notice a difference... ------------- FeRnAN http://www.danasoft.com/"> 
|
Posted By: PrimeraRacer
Date Posted: 25 October 2003 at 11:11am
|
cheers I'll have a look at removing some stuff maybe, although we do need to keep the active users and active topics stuff as they are a requirement of our users :( its a bit wierd though cos it take 10 times longer when your not logged in! Cheers Kev |
Posted By: fernan82
Date Posted: 25 October 2003 at 3:12pm
|
See if you got a lot of PMs in your database and delete them periodically, if you got a whole bunch it takes longer for the database to query for new PMs.
If you need the active users then remove the ones at the bottom, no need to have them twice. Also if your nav bar is the mod that's posted here I just looked at it and it hits the db once for each member to get the username so if you got 10 members online is 10 xtra hits, plus one you use on your site to get the count of active users on the button. It can all be gotten with one, later I will post the one I use in my site as a mod, it gets the amount of members, the amount of guests, and the list of members with 1 hit... ------------- FeRnAN http://www.danasoft.com/">
|
Posted By: MadDog
Date Posted: 25 October 2003 at 6:05pm
|
ljamal, how would you code all of that into one MSSQL query??? ------------- http://www.iportalx.net" rel="nofollow"> 
|
Posted By: ljamal
Date Posted: 25 October 2003 at 6:47pm
|
What I did was I removed the hit for the Configuration and placed it into a configuration file. One hit gone.
I created a join to join the categories and forums. That reduces the category and forum calls (which increases with every forum added) to one query. I returned all the permission for the user in one recordset which I set into an array. and then I took the above along with the rest of the queries on the page and stuck them into one stored procedure and thus all that information is stuck into one database call. Ideally, the database would be rewritten as well. Currently the database is as extremely normalized. By removing some of the normalization, it would make for a better design for the application. First I would add a column for the last post and the last author to the forum table along with the topic and post counts. This same method would follow into the topics area. This would allow direct joins between one or two tables rather than complex joins over multiple tables. For permissions, I would use a stored procedure to create a temp table with the forum information and the base permissions and then update those base permission in the temp table to whatever the permission table altered the value to. There are more things that I would change but those mentined would increase the performance of the forum by placing more of the SQL processing on the SQL server and less of the processing through ASP and multiple SQL calls. This is something that can easily be done with SQL Server, but impossible with Access. If the goal is to continue to support Access and SQL, then I would suggest moving towards saving recordsets into array so that the database recordsets can queried and set aside for later processing. ------------- L. Jamal Walton http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming |