The Arcive of vBulletin Modifications Site.

BigDog56 · #1 07-23-2008, 03: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, 06:08 AM

Which vB version is she running?

Link to the forum?

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

3.7.2 http://ravensforums.com/forums

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

Standard vB 3.7.2 has 146 tables.

Any more are not default tables.

BigDog56 · #5 07-23-2008, 06: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, 07: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, 07: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, 08: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, 11:15 AM

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.