PDA

View Full Version : Modifications and settings for big boards?


Citizen
18 Apr 2006, 16:52
I have a forum that is quickly reaching 100+ new members per day and averaging 100-300 members online.

For performance issues:

What modifications should I have installed? What modifications should I avoid?

I'm running a dual 2.8 xenon 1gb ram dedicated server and I had to turn off:


Members online in the past 24 hours
Members online in threadview
Members online in forumview

Members online in forum home is still enabled and things are running fine. What else should I be doing?

Erwin
19 Apr 2006, 00:31
Upgrading to 2 Gb RAM would also help. ;)

But I would also make sure no-cache headers are OFF. Similar threads is OFF. Using full-text searching. Threadviews not updated instantly. Add index to the ipaddress column in post table. I personally disable Who's Online.

Hacks not to install on a busy forums? The Ajax Shoutbox. :)

GoTTi
29 Apr 2006, 07:50
what do you mean: Add index to the ipaddress column in post table.

??

mlx
29 Apr 2006, 19:54
what do you mean: Add index to the ipaddress column in post table.

??

Running this MySQL query:
ALTER TABLE `post` ADD INDEX `ipaddress` ( `ipaddress` )

makaiguy
30 Apr 2006, 00:06
Another thing suggested to me was Style and Language Settings > Store CSS Stylesheets as Files? > Yes

Can somebody explain what "Add index to the ipaddress column in post table" actually does and how it saves server load?

Paul M
30 Apr 2006, 13:01
Another thing suggested to me was Style and Language Settings > Store CSS Stylesheets as Files? > YesIf you do that then make sure the vbulletin_css folder (inside the clientscript folder) is writable.

Erwin
30 Apr 2006, 14:07
Another thing suggested to me was Style and Language Settings > Store CSS Stylesheets as Files? > Yes

Can somebody explain what "Add index to the ipaddress column in post table" actually does and how it saves server load?
I do that myself. :)