Web Wiz Support and Community Forums : Slow Default.asp load time https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 03 Apr 2026 23:15:52 +0000 Sat, 25 Oct 2003 18:47:20 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=6693 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Slow Default.asp load time : What I did was I removed the hit...]]> https://forums.webwiz.net/slow-default-asp-load-time_topic6693_post32959.html#32959 Author: ljamal
Subject: 6693
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.]]> Sat, 25 Oct 2003 18:47:20 +0000 https://forums.webwiz.net/slow-default-asp-load-time_topic6693_post32959.html#32959 <![CDATA[Slow Default.asp load time : ljamal, how would you code all...]]> https://forums.webwiz.net/slow-default-asp-load-time_topic6693_post32952.html#32952 Author: MadDog
Subject: 6693
Posted: 25 October 2003 at 6:05pm

ljamal,

how would you code all of that into one MSSQL query???

]]> Sat, 25 Oct 2003 18:05:37 +0000 https://forums.webwiz.net/slow-default-asp-load-time_topic6693_post32952.html#32952 <![CDATA[Slow Default.asp load time : See if you got a lot of PMs in...]]> https://forums.webwiz.net/slow-default-asp-load-time_topic6693_post32923.html#32923 Author: fernan82
Subject: 6693
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...]]> Sat, 25 Oct 2003 15:12:44 +0000 https://forums.webwiz.net/slow-default-asp-load-time_topic6693_post32923.html#32923 <![CDATA[Slow Default.asp load time : cheers I&#039;ll have a look at...]]> https://forums.webwiz.net/slow-default-asp-load-time_topic6693_post32891.html#32891 Author: PrimeraRacer
Subject: 6693
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

]]> Sat, 25 Oct 2003 11:11:15 +0000 https://forums.webwiz.net/slow-default-asp-load-time_topic6693_post32891.html#32891 <![CDATA[Slow Default.asp load time : Here&#039;s some things you can...]]> https://forums.webwiz.net/slow-default-asp-load-time_topic6693_post32876.html#32876 Author: fernan82
Subject: 6693
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...

Edited by fernan82]]> Sat, 25 Oct 2003 09:40:22 +0000 https://forums.webwiz.net/slow-default-asp-load-time_topic6693_post32876.html#32876 <![CDATA[Slow Default.asp load time : Without physical rewriting the...]]> https://forums.webwiz.net/slow-default-asp-load-time_topic6693_post32871.html#32871 Author: ljamal
Subject: 6693
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.]]> Sat, 25 Oct 2003 09:02:05 +0000 https://forums.webwiz.net/slow-default-asp-load-time_topic6693_post32871.html#32871 <![CDATA[Slow Default.asp load time : ljamal wrote:Are your SQL server...]]> https://forums.webwiz.net/slow-default-asp-load-time_topic6693_post32854.html#32854 Author: PrimeraRacer
Subject: 6693
Posted: 25 October 2003 at 5:35am

Originally posted by ljamal ljamal wrote:

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.

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

]]> Sat, 25 Oct 2003 05:35:49 +0000 https://forums.webwiz.net/slow-default-asp-load-time_topic6693_post32854.html#32854 <![CDATA[Slow Default.asp load time : God_Struth wrote: PrimeraRacer...]]> https://forums.webwiz.net/slow-default-asp-load-time_topic6693_post32853.html#32853 Author: PrimeraRacer
Subject: 6693
Posted: 25 October 2003 at 5:33am

Originally posted by God_Struth God_Struth wrote:

Originally posted by PrimeraRacer PrimeraRacer wrote:

this IS a confirmed issue with the code on default.asp....



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 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!

]]> Sat, 25 Oct 2003 05:33:25 +0000 https://forums.webwiz.net/slow-default-asp-load-time_topic6693_post32853.html#32853 <![CDATA[Slow Default.asp load time : Are your SQL server and web server...]]> https://forums.webwiz.net/slow-default-asp-load-time_topic6693_post32839.html#32839 Author: ljamal
Subject: 6693
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.]]> Fri, 24 Oct 2003 23:46:40 +0000 https://forums.webwiz.net/slow-default-asp-load-time_topic6693_post32839.html#32839 <![CDATA[Slow Default.asp load time : PrimeraRacer wrote:this IS...]]> https://forums.webwiz.net/slow-default-asp-load-time_topic6693_post32835.html#32835 Author: God_Struth
Subject: 6693
Posted: 24 October 2003 at 9:45pm

Originally posted by PrimeraRacer PrimeraRacer wrote:

this IS a confirmed issue with the code on default.asp....



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.

]]> Fri, 24 Oct 2003 21:45:13 +0000 https://forums.webwiz.net/slow-default-asp-load-time_topic6693_post32835.html#32835