[rt-users] Query Builder

Ruslan Zakirov ruslan.zakirov at gmail.com
Fri Mar 24 04:42:38 EST 2006


As I know that happens since 3.0.x and as I remeber that somehow
related to the code that build next/prev links. I thought this was
fixed in recent versions. Looks like we need to check that again.

On 3/23/06, Luke Vanderfluit <lvanderf at internode.com.au> wrote:
>  Hi.
>
>  Ruslan Zakirov wrote:
>  RT version?
>
>  3.4.5
>
>  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
>
> --
> Best regards, Ruslan.
>
> --
> Luke
>


--
Best regards, Ruslan.


More information about the rt-users mailing list