| Author |
 Topic Search  Topic Options
|
Thithi32 
Newbie
Joined: 03 March 2005
Status: Offline
Points: 12
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Forums are very slow!!
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!
|
 |
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
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.,
|
|
NeutralizeR
Newbie
Joined: 14 December 2004
Location: Turkey
Status: Offline
Points: 35
|
Post Options
Thanks(0)
Quote Reply
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..
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
Duval
Newbie
Joined: 02 December 2004
Status: Offline
Points: 22
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
Thithi32
Newbie
Joined: 03 March 2005
Status: Offline
Points: 12
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
numlosk
Newbie
Joined: 07 July 2005
Location: Denmark
Status: Offline
Points: 1
|
Post Options
Thanks(0)
Quote Reply
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
|
|
Thithi32
Newbie
Joined: 03 March 2005
Status: Offline
Points: 12
|
Post Options
Thanks(0)
Quote Reply
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
|
|
