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.
精彩评论