- 论坛徽章:
- 0
|
我是根据程序需要而设计表的结构,比如一个表的某条记录,就是一个对象的在数据库中的持久化。某个表中的字段也就是某个类的成员变量。
我现在考虑的还是,一个库最多能承受创建多少库? 它的性能如何?它对文件系统的压力如何? mysql manual 上没有过多的说明:
6.4.9. Drawbacks to 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 making the table cache larger. |
|