title: Is a query with over 50 joins slow?
body: <p>I am planning to develop an application using the EAV design. I have done a lot of research on EAV and the sixth normal form. I have even talked to people at work and they say avoid both approaches if you care about your sanity. I had the idea to create tables with over a thousand columns but according to this <a href="https://stackoverflow.com/questions/14949378/what-is-the-performance-of-cubrid-with-a-1000-columns-with-indexes">question</a> that may not be a good idea. So what I wanted to do was instead of creating a thousand columns in one table I am going to create a thousand "one column" tables. This will enable me to separate all the columns into "one column" tables. This will give me ultimate flexibility but I am afraid performance will suffer greatly.</p>
  
  <ul>
  <li>My question is: is a query drastically slow with 50 inner joins (one
  to one)? This database will be powering a public website.</li>
  </ul>