I’m creating some kind of posts and comments system.
I’m wondering what is more effective when it comes to optimalization:
a) containing list of comments in “POST” DB type?
b) creating “POST ID” data type in “COMMENTS” DB and whenever user opens some post workflow is like “do a search for COMMENTS POST ID - THIS POST UNIQUE ID”
What do you think about that?
Let’s say that there could be thousands of comments to one post.