Web Wiz Forums - very slow loading for default.asp page

Print Page | Close Window

very slow loading for default.asp page

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=11415
Printed Date: 08 April 2026 at 9:30pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: very slow loading for default.asp page

Posted By: FARSHAD
Subject: very slow loading for default.asp page
Date Posted: 04 August 2004 at 9:09am

I installed this forum with about 34 forum yest its many forum but i am using SQL 2000 my web server is very fast but the loading of the first page is very slow .

what I should to do

thanks

Replies:

Posted By: WebWiz-Bruce
Date Posted: 04 August 2004 at 11:45am

34 forums is allot and as each forum requires around 4 hits to the database it means that the page is having to make weill over 200 database calls.

Try reducing the number of forums that you have.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: ljamal
Date Posted: 04 August 2004 at 12:14pm

The only other thing to do (if you need all 34 forums) is attempt to optimize the default.asp code to reduce the number of calls.

With a join you can combine the Category and Forum calls to reduce it to one call rather than one call per category. Additionally, if you passed the userID you could join the user and group permissions to that view and get rid of the 2 calls per forum for forum permissions.

I have optimized seferal forums for MSSQL. If you need any help just drop me a PM.

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming