[rt-users] Query Builder

[Ruslan Zakirov]

RT version?

On 3/23/06, Luke Vanderfluit <lvanderf at internode.com.au> wrote:
> Hi.
>
> I've found what appears to be a bug in the query builder.
> When I build a query that needs to do search of contents of tickets.
> Say, for example, I search all tickets with the following query:
>
> Created > '2006-01-01' AND Content LIKE 'foo'
>
> that query could take a very long time to complete, which is normal (not
> acceptable but OK (-:)
>
> After the query has completed I go to delete the "AND Content LIKE
> 'foo'" phrase and the query seems to run again!
>
> I'm looking at the mysql processes that are triggered by this behaviour.
> It seems like the query builder might be using up resources that it
> shouldn't need to.
>
> Can anyone confirm this behaviour? That changing the composition of the
> query actually causes the query to run again?
>
> Thanks.
> Kind regards.
>
> --
> Luke
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>
>
> We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
>


--
Best regards, Ruslan.