[Rt-devel] 3.6.4rc1 performance regression on a fairly complex search (CROSS JOIN???)

[Jesse Vincent]

On May 29, 2007, at 5:09 PM, Joop van de Wege wrote:

> Ruslan Zakirov wrote:
>> On 5/29/07, Jesse Vincent <jesse at bestpractical.com> wrote:
> I ran the query through our Oracle instance and that query is one  
> reason not to migrate.
> I you're interested I can mail the explain plan but suffice to say  
> that it is doing multiple full table scans on users/ 
> cachedgroupmembers.


Right. We already said the query was wrong. ;) It is certainly more  
_Correct_ when searching on multiple requestors. But that doesn't  
make it Right.  Let's let ruslan take a shot at his fix. Worst case,  
we'll go back to the not-as-correct requestor search behaviour.

> Joop
>
> _______________________________________________
> List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/ 
> rt-devel
>