Web Wiz Support and Community Forums : Forums are very slow!! https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 11:50:23 +0000 Thu, 07 Jul 2005 10:32:02 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=15492 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Forums are very slow!! : Numlosk, I don&#039;t have...]]> https://forums.webwiz.net/forums-are-very-slow_topic15492_post86585.html#86585 Author: Thithi32
Subject: 15492
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
]]> Thu, 07 Jul 2005 10:32:02 +0000 https://forums.webwiz.net/forums-are-very-slow_topic15492_post86585.html#86585 <![CDATA[Forums are very slow!! : Hi Thithi32, i have the smae...]]> https://forums.webwiz.net/forums-are-very-slow_topic15492_post86584.html#86584 Author: numlosk
Subject: 15492
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
]]> Thu, 07 Jul 2005 09:46:16 +0000 https://forums.webwiz.net/forums-are-very-slow_topic15492_post86584.html#86584 <![CDATA[Forums are very slow!! : Yes Duval, it works better....]]> https://forums.webwiz.net/forums-are-very-slow_topic15492_post85690.html#85690 Author: Thithi32
Subject: 15492
Posted: 24 June 2005 at 9:30am


Yes Duval, it works better. We added a new field in the forum table inorder to have the id of the last posted message. The home page is a lotfaster 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.



]]> Fri, 24 Jun 2005 09:30:04 +0000 https://forums.webwiz.net/forums-are-very-slow_topic15492_post85690.html#85690 <![CDATA[Forums are very slow!! : ThiThi32: I&#039;m guessing you...]]> https://forums.webwiz.net/forums-are-very-slow_topic15492_post85663.html#85663 Author: Duval
Subject: 15492
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.]]> Thu, 23 Jun 2005 14:41:17 +0000 https://forums.webwiz.net/forums-are-very-slow_topic15492_post85663.html#85663 <![CDATA[Forums are very slow!! : Searching will always take a long...]]> https://forums.webwiz.net/forums-are-very-slow_topic15492_post85565.html#85565 Author: WebWiz-Bruce
Subject: 15492
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 tellingpeople to 'please wait' while the search is being carried out, and forlarger forums the admin will be able to set the amount of time a userhas to wait between seraches so it doen't overload the server and messwith others who are trying to use the forum.
]]> Wed, 22 Jun 2005 11:37:32 +0000 https://forums.webwiz.net/forums-are-very-slow_topic15492_post85565.html#85565 <![CDATA[Forums are very slow!! : My page generation times: 1 sec...]]> https://forums.webwiz.net/forums-are-very-slow_topic15492_post85561.html#85561 Author: NeutralizeR
Subject: 15492
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..
]]> Wed, 22 Jun 2005 08:41:42 +0000 https://forums.webwiz.net/forums-are-very-slow_topic15492_post85561.html#85561 <![CDATA[Forums are very slow!! : firstly 52 forums is quite alot...]]> https://forums.webwiz.net/forums-are-very-slow_topic15492_post85373.html#85373 Author: dj air
Subject: 15492
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 , itmaybe your host, or the number of posts and topics you have.,
]]> Sun, 19 Jun 2005 19:25:04 +0000 https://forums.webwiz.net/forums-are-very-slow_topic15492_post85373.html#85373 <![CDATA[Forums are very slow!! : What can I do to increase WWF...]]> https://forums.webwiz.net/forums-are-very-slow_topic15492_post85264.html#85264 Author: Thithi32
Subject: 15492
Posted: 17 June 2005 at 11:45am

What can I do to increase WWF speed ? ... we just imported the olddatabase messages but now the forums are very slow! (15s/page)

http://www.mfe.org/forums/default.asp

Hope someone can help us. THX!

]]> Fri, 17 Jun 2005 11:45:08 +0000 https://forums.webwiz.net/forums-are-very-slow_topic15492_post85264.html#85264