[rt-devel] Slow Queries part3, Groups

[Matthew Watson]

sure thing..

Sorry if this isn't the correct way for doing patches(had a quick look 
through the archives,
looked ok), pretty new to doing that :)

Find patch attached.

Regards.
Matthew Watson.
Netspace Online Systems.



--On Wednesday, October 15, 2003 9:21 PM -0700 Robert Spier 
<rspier at pobox.com> wrote:

>
>
> 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
>> >
>> >



-------------- next part --------------
A non-text attachment was scrubbed...
Name: IncludeRoleRights.diff
Type: application/octet-stream
Size: 3983 bytes
Desc: not available
Url : http://pallas.eruditorum.org/pipermail/rt-devel/attachments/20031016/28e7ada3/IncludeRoleRights.obj