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? On Sep 26, 1:24 pm, Erol Fornoles <[EMAIL PROTECTED]> wrote: > On Sep 27, 12:47 am, elioncho <[EMAIL PROTECTED]> wrote: > > > 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 > > Better that you keep your data struct as is, IMHO. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
