title: MYSQL: User - profile details table setup - best practice
body: <p>Next to your normal user table "user"(user_id/user_email/user_pwd/etc), what is the best way to go to store profile information?</p>
  
  <p>Would one just add fields to the user table like "user"</p>
  
  <pre><code>(user_id/user_email/user_pwd/user_firstname/user_lastname/user_views/etc)
  </code></pre>
  
  <p>or create another table called "profiles"</p>
  
  <pre><code>(profile_id/user_id/user_firstname/user_lastname/user_views/etc)
  </code></pre>
  
  <p>or would one go for a table with property definitions and another table to store those values?</p>
  
  <p>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?</p>