开发者

Large mySQL table: big table or multiple tables and a view?

I have a user profile table that has 32 fields. These fields are always 开发者_开发百科updated and accessed at the same time. I'm wondering what's the better design, this 32 field-table or split the table into smaller tables and join through a view? Or even, it's possible that the best is split the big table and join it through a SELECT ... JOIN


If the data is not hierarchial, it is of no use to split the table. Instead it will result an extra overhead while executing the joins. On the other hand if you have repetitions of records in this table, go ahead for a split. It will preform better.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜