The Arcive of Official vBulletin Modifications Site.

BigDog56 · #1 07-23-2008, 04:00 AM

My wife runs a small forum. Our hosting company, which is about to change, told me I have an extreme about of tables in phpMyAdmin, 258. Is this about normal? Is there a way to find and delete unnecessary tables?

Marco van Herwaarden · #2 07-23-2008, 07:08 AM

Which vB version is she running?

Link to the forum?

BigDog56 · #3 07-23-2008, 07:32 AM

3.7.2 http://ravensforums.com/forums

Marco van Herwaarden · #4 07-23-2008, 07:42 AM

Standard vB 3.7.2 has 146 tables.

Any more are not default tables.

BigDog56 · #5 07-23-2008, 07:56 AM

Thank you for the reply. The others I take it are from modifications? When you delete a mod, does it automatically delete the table? And if not, will leaving it there cause the forum as a whole to run slow? Sorry for all the questions.

Opserty · #6 07-23-2008, 08:02 AM

Quote:

Originally Posted by BigDog56

Thank you for the reply. The others I take it are from modifications? When you delete a mod, does it automatically delete the table?

It depends on the modification. Most should remove it, however you may find some experience and error or something and so do not remove the tables. Also be aware any other scripts you have on that site may also have their own tables.

Quote:

And if not, will leaving it there cause the forum as a whole to run slow? Sorry for all the questions.

I'm not 100% sure about this but I don't think have loads of tables will have a significant effect, I may be wrong though.

BigDog56 · #7 07-23-2008, 08:13 AM

Quote:

Originally Posted by Opserty

It depends on the modification. Most should remove it, however you may find some experience and error or something and so do not remove the tables. Also be aware any other scripts you have on that site may also have their own tables.

I'm not 100% sure about this but I don't think have loads of tables will have a significant effect, I may be wrong though.

Thank you so much for the info! My soon to be ex hosting company (HostMonster) was tryig to tell me that the average forum only has about 50 tables making my wife's forum extremely large and with all those tables is causing it to run slow.

Dismounted · #8 07-23-2008, 09:50 AM

I would definitely move away from that host - a host shouldn't care about how many tables you have.

Actually - having less tables could affect performance, instead of increasing. Also referred to as the "spreadsheet syndrome".

BigDog56 · #9 07-23-2008, 12:15 PM

Quote:

Originally Posted by Dismounted

I would definitely move away from that host - a host shouldn't care about how many tables you have.

Actually - having less tables could affect performance, instead of increasing. Also referred to as the "spreadsheet syndrome".

I'm learning, lol. I'm moving to Hawk Hosting this weekend. Thank You so much for the info. I've learned alot today.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04390 seconds Memory Usage 2,239KB 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 (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_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 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
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!