vb.org Archive - Total tables in phpMyAdmin

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Total tables in phpMyAdmin (https://vborg.vbsupport.ru/showthread.php?t=186097)

BigDog56

07-23-2008 04:00 AM

Total tables in phpMyAdmin

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

07-23-2008 07:08 AM

Which vB version is she running?

Link to the forum?

BigDog56

07-23-2008 07:32 AM

3.7.2 http://ravensforums.com/forums

Marco van Herwaarden

07-23-2008 07:42 AM

Standard vB 3.7.2 has 146 tables.

Any more are not default tables.

BigDog56

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

07-23-2008 08:02 AM

Quote:

Originally Posted by BigDog56 (Post 1582090)

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

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

07-23-2008 08:13 AM

Quote:

Originally Posted by Opserty (Post 1582092)

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

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

07-23-2008 12:15 PM

Quote:

Originally Posted by Dismounted (Post 1582140)

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

All times are GMT. The time now is 01:03 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01053 seconds Memory Usage 1,726KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: