title: Mysql : multiple tables or one big table?
body: <p>This question has been already asked but I've not found a "1 voice answer".</p>
  
  <p>Is it better to do :</p>
  
  <ul>
  <li>1 big table with :</li>
  </ul>
  
  <p>user_id | attribute_1 | attribute_2 | attribute_3 | attribute_4</p>
  
  <ul>
  <li>or 4 smal tables with :
  user_id | attribute_1</li>
  </ul>
  
  <p>user_id | attribute_2</p>
  
  <p>user_id | attribute_3</p>
  
  <p>user_id | attribute_4</p>
  
  <p>1 big table or many small tables ? Each user can only have 1 value for attribute_X. We have a lot of data to save (100 millions users). We are using innoDB. Performance are really important for us (10 000 queries / s).</p>
  
  <p>Thanks !</p>
  
  <p>François</p>