[GENERAL] Query Question (one group by vs two separate)

2008-12-11 Thread Jonathon Suggs
I'm asking this as a more general question on which will perform better. I'm trying to get a set of comments and their score/rankings from two tables. *comments* cid (integer, primary key) title body *comment_ratings* cid (integer, primary key) uid (integer, primary key) score *Option 1* (Single

Re: [GENERAL] Query Question (one group by vs two separate)

2008-12-15 Thread Jonathon Suggs
On Sat, Dec 13, 2008 at 6:51 PM, Joris Dobbelsteen < jo...@familiedobbelsteen.nl> wrote: > Jonathon Suggs wrote, On 10-12-08 20:12: > >> I'm asking this as a more general question on which will perform better. >> I'm trying to get a set of comments and their score/ran