Jump to content

Column question


Porl123

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.