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

[Ruslan Zakirov]

Hi, Dirk.

Can you try attached patch?

On 5/29/07, Dirk Pape <pape-rt at inf.fu-berlin.de> wrote:
> Halle Jesse, hello Ruslan,
>
> the following ticket search query (captured from the advanced tab) leads to
> very different Searchbuilder compilations in 3.6.3 an 3.6.4rc1 (captured
> from mysql-slow.log):
>
>  Queue = 'trash' AND  (  Requestor.EmailAddress LIKE 'staff@' OR
> Requestor.EmailAddress LIKE 'math.fu' OR Requestor.EmailAddress LIKE
> 'inf.fu' OR Requestor.EmailAddress LIKE 'mi.fu' OR
> Requestor.EmailAddress LIKE 'cedis.fu' OR Requestor.EmailAddress LIKE
> 'zuv.fu' OR Requestor.EmailAddress LIKE 'pcpool.mi' ) AND  (  Status =
> 'new' OR Status = 'open' )
>
> is very straight forward and reasonably fast with 3.6.3:
>
[snip]

-- 
Best regards, Ruslan.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 3.6-try_to_speed_searches_by_watchers.patch
Type: text/x-patch
Size: 2822 bytes
Desc: not available
Url : http://lists.bestpractical.com/pipermail/rt-devel/attachments/20070606/5e8eebb4/3.6-try_to_speed_searches_by_watchers.bin