DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH
 

(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