MySQL - Drawbacks to Creating Large Numbers of Tables in the Same Database
By Arun Desai
MySQL - Drawbacks to Creating Large Numbers of Tables in the Same Database .......
Teacher SiliconIndia replied to Arun Desai Friday, March 19, 2010
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.
