[rt-users] RT Query builder slow

[Ruslan Zakirov]

On 6/28/07, Neil Turner <neil.turner at netbanx.com> wrote:
>
> >> We have mysql 5.022 - can you let us know why that is a problem?
> >Mysql 5.x uses wrong order of joins for a query. We have no solution
> >on RT side. I tried to fix this problem >several times, but now I
> >think we have to file bug into mysql bug tracker.
>
> OK, thanks for the info, however see below
Can you send me explain of the following query? I'm collecting debug
info to make things better.
EXPLAIN SELECT DISTINCT main.* FROM
  ACL ACL_4,
  Groups Groups_3,
  CachedGroupMembers CachedGroupMembers_2,
  Principals Principals_1,
  Users main
WHERE ((ACL_4.PrincipalType = Groups_3.Type))
  AND ((ACL_4.RightName = 'OwnTicket'))
  AND ((CachedGroupMembers_2.MemberId = Principals_1.id))
  AND ((Groups_3.id = CachedGroupMembers_2.GroupId))
  AND ((Principals_1.Disabled = '0'))
  AND ((Principals_1.PrincipalType = 'User'))
  AND ((Principals_1.id != '1'))
  AND ((main.id = Principals_1.id))
  AND ( ACL_4.ObjectType = 'RT::Queue' OR ACL_4.ObjectType = 'RT::System' )
  AND (Groups_3.Domain = 'RT::Queue-Role')
ORDER BY main.RealName ASC;

>
> > How many users you're seeing in the select box? 1-100 is ok, 1000 is not.
>
> We got to the bottom of this, one particular queue had
> privileges set such that Everyone could be an owner of
> a ticket.  The QueryBuilder was attempting to populate
> the Owner dropdown list with everyone who had emailed
> RT (tens of thousands!)
that's what I was talking about. RT is not designed for such setups,
may be we'll deny granting OwnTicket right to Everyone and
Unprivileged groups.

>
> Disabling this feature fixed this problem - QueryBuilder
> now displays in under 3 seconds now.
much better

>
> Thanks
>
> Neil
>
>


-- 
Best regards, Ruslan.