[eluser]flyenig[/eluser]
Lets say you have a database table name "users" and in users u have 50 DB tables. if you query "users" to look for a certain user, will the queries be slower since there is 50 DB fields? If it is slower, will it be noticeable? and What is considered too much?
AND.....
If you go on facebook, and you go to notifications you can manage which type of notifications you want to receive by email. You have a lot of options. (like more then 30)
For example, you can manage emails that will send to you when someone sends you a message, or comments on your post or sends you a friend request etc. How do they do it? Do they store all those options in separate fields in the "users" table that already has the basic 20 fields? Or is that in a separate table?