I have this issue. I have three types of posts a user can generate (some users can generate all some can only generate one type). I have the following types: main, employee and admin posts.
I expect to have to deal with millions of posts (all three types). But about 90% of all posts would be
main_posts. Also, most reads from the DB would be of the
main_posts table would have about 50-100 more fields than what is currently there. update
those fields would be normalized into different tables. The ideea is that the main-posts table would have the bulk of the posts and therefore would have the most reads and writes.
Which design option is more sound?
or Option 2