woolyg Posted November 19, 2008 Share Posted November 19, 2008 Hey all, How many tables are too many in a MYSQL DB, do you think? I've divided up all my info into 2-field tables, all linked by indexes. At the moment, there are about 70 tables, but that could go up to about 100. Has anyone had any issues with DBs with this amount of tables in? Cheers, WoolyG Quote Link to comment https://forums.phpfreaks.com/topic/133302-too-many-tables/ Share on other sites More sharing options...
Zane Posted November 19, 2008 Share Posted November 19, 2008 It's not about having too many tables. Although the ideal thing is to have as few tables as possible while having the utopia of a management system running, you'e still going to end up with some "table overhead" regardless. The key thing is organization. 2 fields per table sounds horrible. Especially for 70 of them. That's a nightmare it seems like. I'm not SQL genious or anything, but yeah. gives me chills. The answer? Organize better. It's just like moving out of your home. Sure, it's great to have 70 boxes on hand, but you're not just gonna put to types of items per box. Hats and shirts in one box. socks and deodorants in another (mind you they're all the same sized boxes). I hope that made sense or I'm just too tired to make analogies now. Quote Link to comment https://forums.phpfreaks.com/topic/133302-too-many-tables/#findComment-693299 Share on other sites More sharing options...
Mchl Posted November 19, 2008 Share Posted November 19, 2008 MySQL says, there are users with more than 60000 tables in single database. As far as I know there is no hardcoded limit for that. But zanus is right. 70 tables, each having two fileds is indicating you have some problems with your database design. Quote Link to comment https://forums.phpfreaks.com/topic/133302-too-many-tables/#findComment-693322 Share on other sites More sharing options...
PFMaBiSmAd Posted November 19, 2008 Share Posted November 19, 2008 You would need to provide specific examples of what your table definitions are and how they are being used to get any specific help. Quote Link to comment https://forums.phpfreaks.com/topic/133302-too-many-tables/#findComment-693358 Share on other sites More sharing options...
c0rnf3d Posted November 19, 2008 Share Posted November 19, 2008 70 2 column tables is fine assuming the items are relational, if they arent relational your doing something wrong. you'll be writing lots of joins Quote Link to comment https://forums.phpfreaks.com/topic/133302-too-many-tables/#findComment-693569 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.