Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions

Reply
 
Thread Tools Display Modes
  #1  
Old 03-04-2012, 05:07 AM
davio33 davio33 is offline
 
Join Date: May 2007
Posts: 65
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Can only make 19,474 forums

So it looks like i can only make 19,474 forum before the poop hits the fan.

When i get to this point the table row will be created, the it never shows in the forum manager or on the site

The _forum table with this many forums is about 4.5mib

I am on a dedicated server with 2 gb rams

Any suggestions on what is causing this?
Reply With Quote
  #2  
Old 03-04-2012, 05:28 AM
DivisionByZero's Avatar
DivisionByZero DivisionByZero is offline
 
Join Date: Dec 2002
Location: South Bend, Indiana
Posts: 485
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

you do realize that all of those forums, their permissions and access masks are read and session stored on each page load, right? you're asking for one slow site =\
Reply With Quote
2 благодарности(ей) от:
ProFifaLeagues, Trevor Hannant
  #3  
Old 03-04-2012, 04:37 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I would strongly, strongly, STRONGLY suggest you not have that many forums. Can you imagine going to a site with that many forums and trying to figure out where to post?!?! Honestly, that is just really not a good idea. Did I strongly recommend against this yet?

You should really look into thread prefixes. Most likely you can do what you want by using them.
Reply With Quote
  #4  
Old 03-04-2012, 04:37 PM
Trevor Hannant's Avatar
Trevor Hannant Trevor Hannant is offline
Senior Member
 
Join Date: May 2003
Location: Edinburgh, Scotland
Posts: 111
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Have to ask, why would you want so many forums? And are you hoping that users will be able to find their way round and post in the correct forum every time?!
Reply With Quote
  #5  
Old 03-04-2012, 04:42 PM
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
Senior Member
 
Join Date: Jun 2008
Location: New York
Posts: 10,610
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm curious what this ~20k forum site look like.
Reply With Quote
  #6  
Old 03-04-2012, 04:54 PM
Amaury Amaury is offline
 
Join Date: Nov 2011
Location: Ellensburg, WA
Posts: 1,075
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by BirdOPrey5 View Post
I'm curious what this ~20k forum site look like.
I am, too. Please give us a link.
Reply With Quote
  #7  
Old 03-04-2012, 05:01 PM
egysc egysc is offline
 
Join Date: Nov 2008
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

whatever the number of created forums , What would be the solution for such problem ? any ideas ?
I'm just need to know in case I needed some thing like that ,
Sorry for interruption .
Reply With Quote
  #8  
Old 03-04-2012, 05:05 PM
Mark.B Mark.B is offline
Senior Member
 
Join Date: Feb 2004
Posts: 1,354
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by egysc View Post
whatever the number of created forums , What would be the solution for such problem ? any ideas ?
I'm just need to know in case I needed some thing like that ,
Sorry for interruption .
In case you needed 20,000 forums??
Reply With Quote
  #9  
Old 03-04-2012, 07:30 PM
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
Senior Member
 
Join Date: Jun 2008
Location: New York
Posts: 10,610
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What are your PHP Memory Limit and MySQL Packet Size settings?
Reply With Quote
  #10  
Old 03-04-2012, 07:40 PM
davio33 davio33 is offline
 
Join Date: May 2007
Posts: 65
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Lynne View Post
I would strongly, strongly, STRONGLY suggest you not have that many forums. Can you imagine going to a site with that many forums and trying to figure out where to post?!?! Honestly, that is just really not a good idea. Did I strongly recommend against this yet?

You should really look into thread prefixes. Most likely you can do what you want by using them.
You don't think vbulletin can scale to that size?

The site is an internal site for a large corporation. I cant go into to much detail, but it will be closed to the public, and each department is assigned, and given a link to a specific forum. Individual forums is the only solution for there needs. They need the features that are available in a VB post/thread, unlike whats available in say wordpress/joomla/wiki/facebook-reddit like script.

I figure vbulletin is the most stable and capable forum to pull it off, at least i hope.

Does vbulletin have limitations on the amount of forums it can do?

The table size, and rows, if you compare that to a large forums _thread / _post tables is actually very small. So im just trying to figure out what is going on here.

--------------- Added [DATE]1330893762[/DATE] at [TIME]1330893762[/TIME] ---------------

Quote:
Originally Posted by BirdOPrey5 View Post
What are your PHP Memory Limit and MySQL Packet Size settings?
120 and 32..thanks for your reply
Reply With Quote
Reply

Thread Tools
Display Modes

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


All times are GMT. The time now is 08:02 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04905 seconds
  • Memory Usage 2,252KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (10)post_thanks_box
  • (2)post_thanks_box_bit
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete