[rt-users] Query Builder

[Luke Vanderfluit]

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
>>
>>_______________________________________________
>>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.
>
>  
>


-- 
Luke

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060323/98c9cb27/attachment.htm>