[rt-users] Slow ticket search page becoming a problem

[Ruslan Zakirov]

Script creates schema and data. The following query must use range
search for the second table instead of 'ref'.

SELECT STRAIGHT_JOIN g.id FROM acl a, grp g WHERE
    g.type = a.type
    AND (
        ( g.domain = 'RT::Ticket-Role' AND g.instance = 10 )
        OR ( g.domain = 'RT::Queue-Role' AND g.instance = 3 )
        OR ( g.domain = 'RT::System-Role' AND g.instance = 1 )
    );




On Nov 18, 2007 6:02 AM, Jesse Vincent <jesse at bestpractical.com> wrote:
>
>
>
>
> On Sun, Nov 18, 2007 at 04:54:03AM +0300, Ruslan Zakirov wrote:
> > Heya, guys.
> >
> > Finally I found some time to test this problem on mysql 5.0 and even
> > has writen a script to reproduce it, but it showed that mysql 5.0.45
> > has no this bug. My script and doogles helped me to prove that it
> > really works as expected. So I really recommend upgrade to 5.0.45 at
> > least for users of 5.0.x.
> >
>
> that's very cool. Can you publish the script so we can test older
> releases to see what release it was fixed in?
>
> -j
>



-- 
Best regards, Ruslan.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: create_data.pl
Type: text/x-perl
Size: 945 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20071118/84f77c2f/attachment.pl>