MySQL - Drawbacks to Creating Large Numbers of T
More DBA job interview questions and answers at
MySQL - 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.
Other Job Interview Questions