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! Link to comment https://forums.phpfreaks.com/topic/208219-column-question/ 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. Link to comment https://forums.phpfreaks.com/topic/208219-column-question/#findComment-1088329 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. Link to comment https://forums.phpfreaks.com/topic/208219-column-question/#findComment-1089314 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.