[dev] MySQL Categories queries

[Chuck Hagenbuch]

Quoting John Morrissey <jwm at horde.net>:

> I'm not sure how best to fix this; hopefully someone better with MySQL
> optimization can step in.

I'm not sure what exactly to take from the examples, but I just want to state
that we *can't* just optimize this for MySQL; it has to be generally efficient
for SQL.

One possibility would be to try and auto-create seperate category tables for
each instance where we currently have a group_uid. Then we could get rid of the
group_uid WHERE clauses.

-chuck

--
Charles Hagenbuch, <chuck at horde.org>
"I'm really... I'm not too fascinated by green food." - Average Joe