Disadvantages of Creating Many Tables in the Same Database

by satheeshkumar 2012-09-19 22:59:32

Disadvantages of Creating Many Tables in the Same Database ,

->If you have many MyISAM tables in the same database directory, open, close, and create operations are slow.
->If you execute SELECT statements on many different tables, there is 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 increasing the number of entries permitted in the table cache.
666
like
0
dislike
0
mail
flag

You must LOGIN to add comments