Database Design Question

Posted by deniz on Stack Overflow See other posts from Stack Overflow or by deniz
Published on 2010-04-07T15:08:05Z Indexed on 2010/04/07 15:13 UTC
Read the original article Hit count: 261

Filed under:
|
|

Hi,

I am designing a database for a project. I have a table that has 10 columns, most of them are used whenever the table is accessed, and I need to add 3 more rows;

View Count
Thumbs Up (count)
Thumbs Down (Count)

which will be used on %90 of the queries when the table is accessed. So, my question is that whether it is better to break the table up and create new table which will have these 3 columns + Foreign ID, or just make it 13 columns and use no joins?

Since these columns will be used frequently, I guess adding 3 more columns is better, but if I need to create 10 more columns which will be used %90 of the time, should I add them as well, or create a new table and use joins?

I am not sure when to break the table if the columns are used very frequently. Do you have any suggestions?

Thanks in advance,

© Stack Overflow or respective owner

Related posts about mysql

Related posts about database