On 9/5/06, Aerik Sylvan aerik@thesylvans.com wrote:
For the purposes of evaluating possible solutions, I think one key question recently brought up here has been under-discussed: how often will this be used? If this will be used very frequently, then the solution will have to be more streamlined and efficient than than if it's going to get less usage.
I'm guessing very high usage. A category such as "American people" is fairly worthless by itself, after all.
we really need a MySQL expert to comment on the performance issues with the join/if exists/group by and count solutions
Well, Domas certainly qualifies as a MySQL expert.