vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Big Board Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=172)
-   -   Modifications and settings for big boards? (https://vborg.vbsupport.ru/showthread.php?t=113341)

Citizen 04-18-2006 02:52 PM

Modifications and settings for big boards?
 
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 04-18-2006 10:31 PM

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 04-29-2006 05:50 AM

what do you mean: Add index to the ipaddress column in post table.

??

mlx 04-29-2006 05:54 PM

Quote:

Originally Posted by GoTTi
what do you mean: Add index to the ipaddress column in post table.

??

Running this MySQL query:
Code:

ALTER TABLE `post` ADD INDEX `ipaddress` ( `ipaddress` )

makaiguy 04-29-2006 10:06 PM

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 04-30-2006 11:01 AM

Quote:

Originally Posted by makaiguy
Another thing suggested to me was Style and Language Settings > Store CSS Stylesheets as Files? > Yes

If you do that then make sure the vbulletin_css folder (inside the clientscript folder) is writable.

Erwin 04-30-2006 12:07 PM

Quote:

Originally Posted by makaiguy
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. :)


All times are GMT. The time now is 02:13 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01117 seconds
  • Memory Usage 1,724KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete