[rt-devel] Slow Queries part3, Groups

[Robert Spier]

Could you make a patch of your changes?  I'd be interested in seeing
them.

Thanks!

-R

At Thu, 16 Oct 2003 10:43:31 +0800,
Matthew Watson wrote:
> 
> This is what I ended up doing. I'm hoping it doesn't break anything,
> I couldn't see anything obvious broken.
> 
> Cheers for the suggestion.
> 
> btw.. this cuts the page load time down to about .2 seconds.
> 
> Regards.
> Matt Watson
> Netspace Online Systems.
> 
> > Another solution, which might be cheating, is to add another argument
> > to WithRight -- IncludeRoleRights, default to 1.  (Going back to the
> > original reason here of building a list of possible owners) While
> > "Owner" implies certain rights, the list of possible owners comes from
> > the Queue, so there's no reason to even perform the Role search
> > (second half above).  You then test for IncludeRoleRights on the line
> > ( if ( defined $args{'Object'} ) { ) that guards the building of the
> > RoleRight part of the query.
> >
> > A little wave of the magic wand, and simple searches run faster.  tada!
> >
> > -R
> >
> >