<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="creating-many-tables">
      </a>
      10.4.3.2 Disadvantages of Creating Many Tables in the Same Database
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045226666304">
  </a>
  <p>
   If you have many
   <code class="literal">
    MyISAM
   </code>
   tables in the same
          database directory, open, close, and create operations are
          slow. If you execute
   <a class="link" href="select.html" title="15.2.13 SELECT Statement">
    <code class="literal">
     SELECT
    </code>
   </a>
   statements on many different tables, there is a little
          overhead when the table cache is full, because for every table
          that has to be opened, another must be closed. You can reduce
          this overhead by increasing the number of entries permitted in
          the table cache.
  </p>
 </div>
 <br/>
</div>
