title: How many columns is too many columns?
body: <p>I've noticed that a lot of folks here cite tables with 20+ (I've seen as much as 55) columns in one table.  Now I don't pretend to be a database design expert, but I've always heard that this is a horrible practice.  When I see this, I usually suggest splitting into two tables with a one to one relationship: one containing the most frequently used data, the other with the least often used data. Though at the same time, there's the possible issue of performance (less JOINs and such).  So my question is this:</p>
  
  <p>When it comes to really LARGE scale databases, is there actually an advantage to having a large amount of columns, despite the fact that this usually leads to many NULL values?</p>
  
  <p>Which is more of a performance hit:  lots of columns with lots of NULLs, or fewer columns with lots of JOINs?</p>