title: Which is more efficient: Multiple MySQL tables or one large table?
body: <p>I store various user details in my MySQL database. Originally it was set up in various tables meaning data is linked with UserIds and outputting via sometimes complicated calls to display and manipulate the data as required. Setting up a new system, it almost makes sense to combine all of these tables into one big table of related content.</p>
  
  <ul>
  <li>Is this going to be a help or hindrance?</li>
  <li>Speed considerations in calling, updating or searching/manipulating?</li>
  </ul>
  
  <p>Here's an example of some of my table structure(s):</p>
  
  <ul>
  <li>users - UserId, username, email, encrypted password, registration date, ip</li>
  <li>user_details - cookie data, name, address, contact details, affiliation, demographic data</li>
  <li>user_activity - contributions, last online, last viewing</li>
  <li>user_settings - profile display settings</li>
  <li>user_interests - advertising targetable variables</li>
  <li>user_levels - access rights</li>
  <li>user_stats - hits, tallies</li>
  </ul>
  
  <hr>
  
  <p><strong>Edit:</strong> I've upvoted all answers so far, they all have elements that essentially answer my question.</p>
  
  <p>Most of the tables have a 1:1 relationship which was the main reason for denormalising them.</p>
  
  <p>Are there going to be issues if the table spans across 100+ columns when a large portion of these cells are likely to remain empty?</p>