Database Structure Question

[sabret00the]

i've got a table

groupid | title | approved
------------------------
data | data | data

however ias part of a query i need to grab both the postcount and membercount of each of these groups, i'm wondering if i should add the additional columns to store the information or should i just grab the information via a leftjoin and SELECT COUNT query?

[Natch]

JOIN it would be best I think, unless you wanna create caches and store the results in the datastore (not ideal with a constantly updated value like postcounts).

[sabret00the]

thanks natch, will go about tit that way then :)