title: How big is too big for a view in MySQL InnoDB?
body: <p><strong>BACKGROUND</strong></p>
  
  <p>I'm working with a <code>MySQL</code> <code>InnoDB</code> database with 60+ tables and I'm creating different views in order to make dynamic queries fast and easier in the code. I have a couple of views with INNER JOINS (without many-to-many relationships) of <code>20 to 28 tables</code> SELECTING <code>100 to 120 columns</code> with <code>row count below 5,000</code> and it works lighting fast. </p>
  
  <p><strong>ACTUAL PROBLEM</strong></p>
  
  <p>I'm creating a master view with INNER JOINS (without many-to-many relationships) of <code>34 tables</code> and SELECTING about <code>150 columns</code> with <code>row count below 5,000</code> and it seems like it's too much. It takes forever to do a single SELECT. I'm wondering if I hit some kind of view-size limit and if there is any way of increasing it, or any tricks that would help me pass through this apparent limit. </p>
  
  <p>It's important to note that I'm <strong>NOT USING</strong> <code>Aggregate functions</code> because I know about their negative impact on performance, which, by the way I'm very concerned about.</p>