Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
  #1  
Old 10 Oct 2007, 18:57
Majidm Majidm is offline
 
Join Date: Aug 2005
Multiple private forums - huge memory/server load?

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.

Cheers,

-m
Reply With Quote
Comments
  #2  
Old 14 Oct 2007, 19:34
Lord.Khalid Lord.Khalid is offline
 
Join Date: Sep 2006
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
Reply With Quote
  #3  
Old 17 Oct 2007, 00:37
0tolerance 0tolerance is offline
 
Join Date: Jun 2007
welll why dont you try this?
http://www.vbulletin.org/forum/showt...highlight=grps
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.
__________________
Exasco.info - Exasco is a community that helps people, there’s no fees, just friendships.
Reply With Quote
  #4  
Old 17 Oct 2007, 00:49
nexialys
Guest
 
... 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...
Reply With Quote
  #5  
Old 09 Apr 2008, 16:09
Majidm Majidm is offline
 
Join Date: Aug 2005
We got rid of all the extra usergroups and hacked up our own "extra" forums. Things are fast now
Reply With Quote
  #6  
Old 10 Apr 2008, 01:48
iogames's Avatar
iogames iogames is offline
 
Join Date: Jan 2007
Real name: Josh Arcadia
Originally Posted by Majidm View Post
We got rid of all the extra usergroups and hacked up our own "extra" forums. Things are fast now
Great site! [you revive my hope in vBulletin ]
__________________
. █│║▌│█│║▌║│█║▌│║║█║
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 21:38.

Layout Options | Width: Wide Color: