Database optimization approach

Rails
1

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?

Thanks,

Elioncho

2

On Sep 27, 12:47 am, elioncho [email protected] wrote:

Thanks,

Elioncho

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

3

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?