[rt-devel] Slow Queries part3, Groups

[Robert Spier]

> I'm not best of best in DBs, but I want draw your attention to table 
> Principals and where clauses of this select.
> First of all, we use only id from this table.
> Second, in accordance with RT::Group->PrincipalObj

I don't believe the Principal's stuff is the slow part of this query.
(At least not from my analysis of the EXPLAIN output.)  I know the
Principal stuff is there for a reason, I believe it has to do with
delegation of rights, but Jesse can explain that better.

> And at last, query MUST be:
> SELECT DISTINCT main.*

What did I screw up?

-R