[rt-users] Re: [PERFORMANCE][PATCH] Searches by watchers with OR aggregator

Ruslan Zakirov ruz at bestpractical.com
Mon Jul 30 11:42:35 EDT 2007


yes, it can, but I really would like to hear from other users about
the patch. Especially I'm interested in reports from people who are
using 4.1.22 and have many tickets and many users in the DB.

On 7/30/07, Brian Kerr <kerrboy at gmail.com> wrote:
> Hey Ruslan,
>
> Can the patch be reworked to use the third query that you had sent to me?
>
> Thanks,
> Brian
>
> On 7/25/07, Ruslan Zakirov <ruz at bestpractical.com> wrote:
> >   Hi, guys.
> >
> > Thank you for the feedback. Here is patch that should address
> > performance problems with queries like:
> > "Owner = X OR Requestor = Y"
> > "Requestor = Y OR Status = X"
> > and other queries where positive search conditions (=, like ...) on
> > Requestor, Cc, AdminCc or Watchers are joined with other conditions
> > using OR. It doesn't apply to queries with all ANDs, as well it's not
> > about searches by links, dates or something else. It's about watchers
> > and ORs.
> >
> > --
> > Best regards, Ruslan.
> >
> >
>


-- 
Best regards, Ruslan.



More information about the rt-users mailing list