Porl123 Posted July 19, 2010 Share Posted July 19, 2010 I have a users table which has 28 fields in it but I've been told that it's bad use of MySQL to have this many fields in one table. I just thought that if I kept all the essential information in one table then it would require less queries. I have made the majority of my website and it's a big website but I was wondering how far I could take the column count before it starts affecting anything. By the time the site is finished it could easily be up to 50 fields, so I just wanted to know how cautious I should be. If it's just a case of the table looking untidy I don't really mind, I keep it organised. I've heard the average limit before mysql stops accepting new columns is a few thousand so I'm not that worried. If anyone can shine some light on this I'd be grateful. Thanks! Quote Link to comment Share on other sites More sharing options...
Porl123 Posted July 19, 2010 Author Share Posted July 19, 2010 By the way, I never select all when using select queries if that makes any difference. Quote Link to comment Share on other sites More sharing options...
fenway Posted July 21, 2010 Share Posted July 21, 2010 Assuming your DB design is reasonable, 28 is nowhere near a problem. Quote Link to comment 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.