Forums are very slow!!
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=15492
Printed Date: 13 April 2026 at 11:47am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Forums are very slow!!
Posted By: Thithi32
Subject: Forums are very slow!!
Date Posted: 17 June 2005 at 11:45am
|
What can I do to increase WWF speed ? ... we just imported the old
database messages but now the forums are very slow! (15s/page) http://www.mfe.org/forums/default.asp Hope someone can help us. THX! |
Replies:
Posted By: dj air
Date Posted: 19 June 2005 at 7:25pm
|
firstly 52 forums is quite alot even for a SQL version. when you say import do you mean from a 3rd party forum or upgraded? if upaded the indexss need time to work, but if from a 3rd party , it maybe your host, or the number of posts and topics you have., |
Posted By: NeutralizeR
Date Posted: 22 June 2005 at 8:41am
|
My page generation times: 1 sec or less... But if somebody makes a search in the forum it is between 10-20 secs...
i'm using sql server... what do u suggest ?
P.S. There are no junk topics, messages.. ------------- http://www.MsXLabs.com"> 
|
Posted By: WebWiz-Bruce
Date Posted: 22 June 2005 at 11:37am
|
Searching will always take a long time as looking through each and every post for words does take along time. In the next version I'm planning on having a message display telling people to 'please wait' while the search is being carried out, and for larger forums the admin will be able to set the amount of time a user has to wait between seraches so it doen't overload the server and mess with others who are trying to use the forum. ------------- 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: Duval
Date Posted: 23 June 2005 at 2:41pm
|
ThiThi32: I'm guessing you got it sorted. Seems prettty quick to me. I get Cette page a été affichée en 0,3594 secondes. ------------- http://www.oversite.us - OverSite free submission for qualiy sites. (no reciprocal link required) |
Posted By: Thithi32
Date Posted: 24 June 2005 at 9:30am
|
Yes Duval, it works better. We added a new field in the forum table in order to have the id of the last posted message. The home page is a lot faster without searching for the last message of each forum. Concerning the search we're currently working on optimizing the queries with indexation catalogs. We'll see soon how it works. |
Posted By: numlosk
Date Posted: 07 July 2005 at 9:46am
|
Hi Thithi32,
i have the smae trouble as you, and your idea is great i just wanna know where did you add the field to order the table, and in what section of the code should i insert this to improve my home forum speed...
Thanks, i hope you can help me to solve this problem and start enjoying this awesome forum...
Thaks
|
Posted By: Thithi32
Date Posted: 07 July 2005 at 10:32am
|
Numlosk,
I don't have much time to answer, since it is a little complex to explain.
But quickly what we did:
- For the home page we added the following fields
(Last_Entry_Message_ID, Last_Entry_Topic_ID, Last_Entry_Date, Last_Entry_User, Last_Entry_User_ID) to tblForum table, in order to have the informations about the last posted message of the forum without browsing the DB.
- For the search we created 3 indexed catalogs (topic, message and user name) that help finding quickly the messages.
Hope it'll help,
Thithi32
|