On 6/28/07, Neil Turner <[EMAIL PROTECTED]> 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.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
