title: MySQL name and surname in 2 columns vs name in 1 column
body: <p>One simple question and I couldn't find any answers to id :</p>
  
  <p>Should name be in 2 different DB columns ( name / surname ) or in 1 column ( name + surname ) ? </p>
  
  <p>In all the projects I had they were in 2 different columns, but now I have to start a new project and I was wantering how it better to store it. I mean, the 2 different columns gave me a bit of trouble and sometimes slowed performance down. Please note this very important thing :</p>
  
  <ul>
  <li>A very important part of the public part of the site will be an advanced search and it WILL search for the full name in about 200k records.</li>
  </ul>
  
  <p>So, what do you suggest ? 2 columns or 1 ? I am inclined twords the 1 column solution because I cannot find any advantages in using 2, but maybe I am wrong ?</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>Thank you for the answers. The only reason for this question was for the performance issue, I need all the extra boost I can get.</p>