<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="optimize-multi-tables">
      </a>
      10.4.3 Optimizing for Many Tables
     </h3>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="table-cache.html">
       10.4.3.1 How MySQL Opens and Closes Tables
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="creating-many-tables.html">
       10.4.3.2 Disadvantages of Creating Many Tables in the Same Database
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <a class="indexterm" name="idm46045226732304">
  </a>
  <p>
   Some techniques for keeping individual queries fast involve
        splitting data across many tables. When the number of tables
        runs into the thousands or even millions, the overhead of
        dealing with all these tables becomes a new performance
        consideration.
  </p>
 </div>
 <br/>
</div>
