(mysql.info.gz) Creating many tables
Info Catalog
(mysql.info.gz) Table cache
(mysql.info.gz) Optimizing Database Structure
7.4.9 Drawbacks to Creating Many Tables in the Same Database
------------------------------------------------------------
If you have many `MyISAM' or `ISAM' tables in a database 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.
Info Catalog
(mysql.info.gz) Table cache
(mysql.info.gz) Optimizing Database Structure
automatically generated byinfo2html