Go Back   vb.org Archive > Community Discussions > Forum and Server Management
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 07-03-2009, 07:34 AM
maidos maidos is offline
 
Join Date: Jul 2006
Posts: 925
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default vb db seem a bit too big

have 12k+ members and over 100 000 posts but 350mb large database seems a bit too big? im not sure its normal. i do have few mods installed but they are just roughly 10 mb totally
Reply With Quote
  #2  
Old 07-03-2009, 09:02 AM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Doesnt seem that big to me, what makes you think it is ? Also, where are your attachemnts stored ?
Reply With Quote
  #3  
Old 07-05-2009, 04:20 PM
maidos maidos is offline
 
Join Date: Jul 2006
Posts: 925
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

well it sounds a bit big too me since ive seen webmasters with 50mb of database.
Attachment stores in filesystem
Reply With Quote
  #4  
Old 07-06-2009, 09:01 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

350Mb is nothing special. I am running a forum that has a backup of more then 20Gb.
Reply With Quote
  #5  
Old 07-06-2009, 01:54 PM
TheLastSuperman's Avatar
TheLastSuperman TheLastSuperman is offline
Senior Member
 
Join Date: Sep 2008
Location: North Carolina
Posts: 5,844
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Just a note, I tried to tell the creators of the Mod here --> https://vborg.vbsupport.ru/showthread.php?t=217329

THAT, some hosts limit DB sizes... you already have one that equals 350mb so I doubt your host does but consider your users and posts counts so that seems the norm but I help run a gaming tournament so we have never have tons of users plain and simple due to the fact we delete inactive users and posts once they get so old to maintain army numbers and accurate counts all around for battledays etc... We're gamers lol, what can I say .

Not everyone needs or wants a huge DB but that depends on what type of forums you run and how "active" you want your site to be by using SEO and other methods like the mod above.

Just a side note to any future passers-by to be aware of w/ their host.

S-MAN
Reply With Quote
  #6  
Old 07-06-2009, 02:04 PM
deadlySniper deadlySniper is offline
 
Join Date: Dec 2008
Location: New York
Posts: 211
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hmm, Sounds rather big. I have a database with 90k members, and around 100k posts, and that's only 90mb.
Reply With Quote
  #7  
Old 07-07-2009, 09:04 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Number of members, and even the number of posts is not a reliable indicator for the DB size. A lot of factors like the size of posts, the number & size of attachments etc, make a greater difference.
Reply With Quote
  #8  
Old 07-07-2009, 01:44 PM
1Unreal 1Unreal is offline
 
Join Date: Jul 2008
Location: London
Posts: 372
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by TheLastSuperman View Post
Just a note, I tried to tell the creators of the Mod here --> https://vborg.vbsupport.ru/showthread.php?t=217329

THAT, some hosts limit DB sizes... you already have one that equals 350mb so I doubt your host does but consider your users and posts counts so that seems the norm but I help run a gaming tournament so we have never have tons of users plain and simple due to the fact we delete inactive users and posts once they get so old to maintain army numbers and accurate counts all around for battledays etc... We're gamers lol, what can I say .

Not everyone needs or wants a huge DB but that depends on what type of forums you run and how "active" you want your site to be by using SEO and other methods like the mod above.

Just a side note to any future passers-by to be aware of w/ their host.

S-MAN
Well that mod uses an independent database so you could come up with work around. Also, if you cant handle it dont use it.
Reply With Quote
  #9  
Old 07-10-2009, 01:16 PM
maidos maidos is offline
 
Join Date: Jul 2006
Posts: 925
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

ok thanks alot for youreply, im less concerned now =)
Reply With Quote
Reply


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 01:14 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04267 seconds
  • Memory Usage 2,237KB
  • Queries Executed 11 (?)
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
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (9)postbit
  • (9)postbit_onlinestatus
  • (9)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_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
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete