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

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

Hi Arun,
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.