Forums are getting slower and slower everyday.

Posted: Tue Mar 09, 2004 11:10 am

The site started to get busy and people started to post in forums a lot because of become a "premium membership" and now site, ecpecially forums. People are getting very pissed off, I remember reading few posts by Pual (ZX) about speeding up forum's speed, but can't seem to find them.
Any idea guys?

http://www.pakistanimedia.com/pm

Posted: Thu Mar 11, 2004 10:58 am

So no one has seen any problem like mine huh?

Posted: Thu Mar 11, 2004 11:06 am

Do you 'Optimize' the database regularly?

What are page gens up to?

Posted: Thu Mar 11, 2004 11:14 am

Yeah I do optimize database almost everyday and generation time is not bad at all, between 0.5x to 0.7 when logged in as an admin and user.

Posted: Thu Mar 11, 2004 11:20 am

Change your site theme and see if that helps at all. Go via Your_Account and it wont upset other users.

Nuke Soldier Joined: Dec 23, 2003 Posts: 19

Mesum wrote:

People are getting very pissed off, I remember reading few posts by Pual (ZX) about speeding up forum's speed, but can't seem to find them.
Any idea guys?

I think this article is what you are looking for.

Lieutenant Joined: Dec 30, 2003 Posts: 283

If you forum gets "large", then there are quite a few ways to speed it up. Head over to www.phpbb.com and look for posts by "lanzer" http://www.phpbb.com/phpBB/viewtopic.php?t=135383&highlight=lanzer

Hope this helps. All solutions that I am pointing you to, most likely require code hacking.

You can immediately gain a good deal of performance by implementing what djmaze and I collaborated on. It is here:
http://www.nukecops.com/postlite22767-.html

steve

Nuke Soldier Joined: Mar 20, 2004 Posts: 12

Daniel-cmw wrote:

Do you 'Optimize' the database regularly?

What are page gens up to?

Well this is something I had forgotten about.... Duh! I went and optomized from the admin and man there was a lot that got optomized....
My site uses the IM (site messenger) a lot, and I understand this is connected to the forums via prvt msg. So I guess this optomization clears out old deleted messages? I'm am going to make the optomization part of my regular routine.

I'm here in search of other things I should be doing to help speed up my post time. Often times it errors out because it takes so long after the submit button is hit. I get double posts, and errors a lot cuz it just sits there a lot when submit is hit. It's scarey! I'm a relative newbie to nuke admin. The optomize is the first thing I'll do. If someone can point me to the simple fixes I'd be greatful. I'm reading, and trying to absorb. SOme of the terms are new to me... I've been running nuke for less than 6 mos and by the seat of my pants... LOL It's scarey how slow it reacts tot he submit button sometimes... Thanks in advance...

Lieutenant Joined: Dec 30, 2003 Posts: 283

If you have shell access, then look at the timing of mysql's http://nukecops.com/postlite35644-slow+query.html

This is my one single recommendation. After viewing them for a while, you can start optimizing.

If you don't have shell acess, there is some good code that tama has posted for doing similar thing. Search for "tama slow query".

Nuke Soldier Joined: Mar 20, 2004 Posts: 12

steven111 wrote:

If you have shell access, then look at the timing of mysql's http://nukecops.com/postlite35644-slow+query.html

This is my one single recommendation. After viewing them for a while, you can start optimizing.

If you don't have shell acess, there is some good code that tama has posted for doing similar thing. Search for "tama slow query".

Thank you Steven. Seems you are helping everyone! I'm going to give this a try. Thanks.

Nuke Soldier Joined: Mar 20, 2004 Posts: 12

steven111 wrote:

If you have shell access, then look at the timing of mysql's http://nukecops.com/postlite35644-slow+query.html

This is my one single recommendation. After viewing them for a while, you can start optimizing.

If you don't have shell acess, there is some good code that tama has posted for doing similar thing. Search for "tama slow query".

Oh I'm sorry I should ask what "shell" is. I am running the site from a server I setup on one of my machines here at home. I'm using windows 2000 pro. It all comes from my home. So I have access to everything on the system. Is this what you mean? I'm reading the thread you linked for me. Thanks again.

Oh I see the shell has to do with Unix. This is a Windows 2000 Pro system. The only way I know to access MySQL is via the admin page. I have executed scripts that give the commands for me but I've never done commands lines to the database. I'm failry good with DOS and so I could probably do the syntax properly if I knew what that syntax is. I'll read some more. I know that's my best bet. Also I'm listening...

Nuke Soldier Joined: Mar 20, 2004 Posts: 12

Daniel-cmw wrote:

Change your site theme and see if that helps at all. Go via Your_Account and it wont upset other users.

I have a custom theme installed. It's a nice looking theme, but if it's going to slow down the system I'll go back to SubSilver. My users have been throwing their hands up and complaining bigtime. I'll definitely try toggling back to Sub Silver and see how it acts. Thanks for the heads up.

Oh BTW:

Since you suggest the theme might actually be slowing it down, let me ask you this (if I may): SInce you probably know what is causing this (thus your suggestion), is there anything I could do to make this nice theme I'm using act better. I'm investigating what you mention here. Thanks.

Lieutenant Joined: Dec 30, 2003 Posts: 283

FJ wrote:

steven111 wrote:

If you have shell access, then look at the timing of mysql's http://nukecops.com/postlite35644-slow+query.html

This is my one single recommendation. After viewing them for a while, you can start optimizing.

If you don't have shell acess, there is some good code that tama has posted for doing similar thing. Search for "tama slow query".

Oh I'm sorry I should ask what "shell" is. I am running the site from a server I setup on one of my machines here at home. I'm using windows 2000 pro. It all comes from my home. So I have access to everything on the system. Is this what you mean? I'm reading the thread you linked for me. Thanks again.

Oh I see the shell has to do with Unix. This is a Windows 2000 Pro system. The only way I know to access MySQL is via the admin page. I have executed scripts that give the commands for me but I've never done commands lines to the database. I'm failry good with DOS and so I could probably do the syntax properly if I knew what that syntax is. I'll read some more. I know that's my best bet. Also I'm listening...

You can do it with Win as well. Just use winmysqladmin GUI to set the startup parameters (make changes from "my.ini" tab in), restart mysql (from the same tool), and then you can simply look at the log file from Win or from Dos.

Alternatively implement tama's solution which does not need shell access (search for tama slow query) on this forum.

Sergeant Joined: Aug 26, 2004 Posts: 75

The main problem is the bbwords table.
It is almost even as big as your whole forum.

It stores each and every word/numeric that gets posted by people.
So the bigger the list the slower it gets because on each post/edit it has to check your message and subject to the list and make changes.

If you drop the table the search won't work anymore Wink

Changing the search system could work but be aware that you can't INDEX KEY a TEXT/BLOB because that is limited to 500 chars unless you explicit add a KEY say: INDEX post_text(50) or something

I also think this will only work on MyISAM tables, but i have to ask DJ for that

Lieutenant Joined: Dec 30, 2003 Posts: 283

FreeBee wrote:

The main problem is the bbwords table.
It is almost even as big as your whole forum.

It stores each and every word/numeric that gets posted by people.
So the bigger the list the slower it gets because on each post/edit it has to check your message and subject to the list and make changes.

If you drop the table the search won't work anymore Wink

Changing the search system could work but be aware that you can't INDEX KEY a TEXT/BLOB because that is limited to 500 chars unless you explicit add a KEY say: INDEX post_text(50) or something

I also think this will only work on MyISAM tables, but i have to ask DJ for that

First, you have to get a handle on timing. Either implement mine or Tama's sql timing system.

If your forum is big, then bbwords table could be a problem (or could be that you are missing indecis here and there, so you gotta check first). If bbword is a problem, there are some good solutions
(a) don't keep history, i.e. remove indexing for older topics
(b) only index the topic starter post, and ignor the replies
The above two solutions will give you pretty good performance without sacrificing a lot of user functionality