View Full Version : Max # of usergroups/userforums ?
mindbuster
Fri 24th Dec '04, 12:23pm
Im starting another site, for this i this time purchase the owned license, the site is for a mmorpg forum which have alot of societies (clans), each socitety should have access to their own private forum that only society members can access (society=usergroup).
What is the limit on amount of usergroups and subforums in vB ?
Floris
Fri 24th Dec '04, 12:28pm
In theory there isn't a limit. I think the limit is what the MySQL can store in its fields ..
Quite a few I think.
mindbuster
Fri 24th Dec '04, 12:29pm
Atleast 32384 i guess then :D
Cool, thnx for answering.
Floris
Fri 24th Dec '04, 12:34pm
I have never tested setting up and working with 250 or more usergroups. So that would be a nice test.
emmel
Fri 25th Apr '08, 5:12am
We currently have about 1000 groups (that get automatically downloaded from the CRM) and performance seems to get worse and worse. Currently we have about 7 sec response time. There seems to be a data structure in the database called usergroupcache in the datastore relation. It is about 14 mega bytes now and that gets loaded on every page request. Apparently just loading it from the db takes almost that long.
Is there any way around that, possibly not using the usergroupcache ?
Andy Huang
Fri 25th Apr '08, 2:37pm
memcache would most likely help, as the cache would be part of the datastore and be cached by the memcache daemon; aside from that, I can't think of anything major :X
Floris
Thu 1st May '08, 8:27pm
Please do not bump 4 year old threads. Thread closed.
vBulletin® v3.8.0 Release Candidate 1, Copyright ©2000-2008, Jelsoft Enterprises Ltd.