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

2008-12-15 Thread Jonathon Suggs
Thanks Joris. I'm familiar with explain and I do use it quite frequently. My site is just starting out so I don't think performance is that crucial of an issue at the onset (premature optimization). Also, there is not that much data yet so its difficult to have a very accurate picture of what a

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

2008-12-13 Thread Joris Dobbelsteen
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/rankings from two tables. *comments* cid (integer, primary key) title body *comment_ratings* cid (integer, primary key) uid (i