Database optimization approach

Hello everyone,

I'll like to hear your opinion on the following issue. I have a posts
and post_comments table. Posts belong to a group, so there is a
group_id column on it. I want to query for all the post_comments of a
user for a specific group, so what I am doing now is a INNER JOIN
between the two tables. My question is: Is it better to have a
group_id column on the post_comments table for optimize search or
that's redundant?



Better that you keep your data struct as is, IMHO.

Agree with Erol. Leave the schema as it is, and use proper DB indexes
to help with performance.

It is posts that belong to groups, not comments. Right?