vBulletin Mods

The Official vBulletin Modifications Site

Multiple private forums - huge memory/server load?
by Majidm
10 Oct 2007 17:57

Hi all,

We're running VB in a context where we allow users to create private forums for their "groups" of people. Since VB doesn't support "auto deny access UNLESS allowed", we're forced to explicitly deny permissions to every usergroup in existence every time someone creates a group forum. Since creating a forum also implies creating a usergroup (in our setup), we have sort of run into a wall of memory usage. The 'forumscache' array has 279 forums, and the 'forumpermissions' array has 280 members, which results in each of the forums having 280 permissions, i.e. a mega-array with close to 80,000 constituents in it. Of course, this means huge server load and tremendous memory usage (not to mention unserialize() taking FOREVER).

I'm looking at one of the following options - maybe someone could suggest me something alternative too? (I looked at thread prefixes - but the idea is I really want users to have their own private forums that nobody else can see).

a) hacking the permissions system to automatically DENY access if it can't find the correct entry in the 'forumpermission' table (right now, if a user creates a new forum, everybody can automatically view its contents unless I manually INSERT permission 0 for his forumID for EACH usergroup on the site, and I have to do this retroactively every time I create a new usergroup. The 'forumpermission' table has 470,000 entries..... hehe).

b) hacking the forumcache system that it would hit the database every time it needed to access for forumcache->forumpermission[$forumID] - I'm certain it would be faster than parsing a 80,000 object array;

c) --?? some other magical alternative.

Would anybody have any ideas, or hints on a) / b)? I actually don't really know (for now) which parts I'd need to hack - thought I'd throw the question out and start researching after in hopes someone has dealt with this.



Lord.Khalid 14 Oct 2007 18:34

why you don't use a password instead of permissions?

Use password and change it regularly or gave the group leader permission to change it, so you can keep that forum private.

I use it in my forum with permissions, but it just 6 groups, I think 279 it is too much to use it with permissions.

Hope that useful

Good Luck

0tolerance 16 Oct 2007 23:37

welll why dont you try this?
it gives your users the ability to have their own groups and the group creator is the moderator of the group and theres heaps of other stuff.. but its good.

nexialys 16 Oct 2007 23:49

... because the GRPS is a complete seperate system from the forum and is not manage the same way, having it for a lot of groups would overload the system faster than having a large forum...

Majidm 09 Apr 2008 15:09

We got rid of all the extra usergroups and hacked up our own "extra" forums. Things are fast now

iogames 10 Apr 2008 00:48


Originally Posted by Majidm (Post 1486721)
We got rid of all the extra usergroups and hacked up our own "extra" forums. Things are fast now

Great site! :up: [you revive my hope in vBulletin ;)]

All times are GMT. The time now is 01:56.

Powered by vBulletin® Version 3.8.12
Copyright © 2019, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.