[rt-users] Slow ticket search page becoming a problem
ruslan.zakirov at gmail.com
Sun Nov 18 14:17:42 EST 2007
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
( 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?
Best regards, Ruslan.
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 945 bytes
Desc: not available
More information about the rt-users