title: Split db table for performance?
body: <p>I have a big "users" table with most of the columns (user profile) only occasionally needed, whereas a few columns (user credentials) very often. I don't like to fetch the whole row with the profile just to display the user's name. </p>
  
  <p>Would splitting the table in two, ie. users and profiles be better performance wise, or worse (having to make two queries for the profile)? Is there a performance difference in MySql between fetching a row with just a few columns vs. lets say a hundred?</p>
  
  <p>Thank you.</p>
  
  <p>I should have mentioned that I'm on the Laravel framework. I would have to use Raw queries to SELECT the columns. I don't like the idea, but I`ll look into that.</p>