GNU Info

(mysql.info)Creating many tables

---

Next: Open tables Prev: Table cache Up: Optimizing Database Structure

---

Enter node , (file) or (file)node

Drawbacks to Creating Large Numbers of Tables in the Same Database
------------------------------------------------------------------

If you have many files in a directory, open, close, and create
operations will be slow.  If you execute `SELECT' statements on many
different tables, there will be 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 making the table cache larger.