MYSQL: User - profile details table setup - best practice

RookyRajokPem

New Member
Next to your normal user table "user"(user_id/user_email/user_pwd/etc), what is the best way to go to story profile information.Would one just add fields to the user table like "user"(user_id/user_email/user_pwd/user_firstname/user_lastname/user_views/etc)or create another table called "profiles"(profile_id/user_id/user_firstname/user_lastname/user_views/etc)or would one go for a table with property definitions and another table to store those values.I know the last one is the most flexible, as you can add and remove fields easily.But for a big site (50k users up) would this be fast?
 
Back
Top