Board with 4000 forums, 1 million page view per day

[funfun168]

We are going to make a community board based on cities, there are expected 4000 forums in it and right now the page view is assumed to be 1 million per day

I know there is caching problem if there are such many number of forums in a board, are there any ways to solve this?

Is there any suggestion for the server and config? Thank you

[RS_Jelle]

Some suggestions:

• Use definitely InnoDB instead of MyISAM as the storage engine for your database tables (row level locking).
• Optimize your database every night to prevent a lot of overhead.
• Use datastore filecaching (link)
• Turn off some options (link)
• Turn on GZIP (lowest level of it)
• Compress your HTML output (link)
• Put on the vBulletin option to store CSS stylesheets in a file (smaller pages)
• Close your search for guests, some minimum time between two searches (30 seconds or more) and close your search when you have a high server load (link)
• ...

And ofcourse some very good servers. I suggest you to use minimum two servers: a webserver and a databaseserver. Use very good servers (much memory, a good RAID 5 config, dualcore opterons, ...) and configure them very good. Ask eva2000 more about this on vB.com.

[funfun168]

Thank you RS_Jelle
Vbulletin seems load all the forum into the forumcache on each page. With 4000 forums that would be an immense amount of data. This seem the biggest problem for me. Do you mean that some of the above suggestion addressed to this issue?

[funfun168]

this is the reply from other board web site
"I understand the issue and the main problem you will have is the forum cache. All forum and moderator information is cached in the main cache and so even if you do segment the forum listings up the cache will still be carried around.

To successfully implement this you would need to have a small mod to allow for certain forums to 'belong' to a certain city. This way you can just have at the top index.php?city=london (for example) and that will show all forums for London (plus maybe some global forums such as Announcements and General Chat.

Then you will need to assign a forum cache for each city. Not amazingly hard as you would just have a ACP feature to make a city and once the city is added it also creates an extra DB row for that forum city cache. You would then need to mod the index.php to make sure the cache isnt pulled globally but for each city (dependant on the city you are viewing)."

Can I do this in vbulletin?

[Paul M]

You can do most things if you can find someone to write it for you.