On 9/5/06, Aerik Sylvan <aerik(a)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.