<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi.<br>
<br>
Ruslan Zakirov wrote:
<blockquote
cite="mid589c94400603221442l71838b33p8a86ec9876cff752@mail.gmail.com"
type="cite">
<pre wrap="">RT version?
</pre>
</blockquote>
3.4.5<br>
<br>
<blockquote
cite="mid589c94400603221442l71838b33p8a86ec9876cff752@mail.gmail.com"
type="cite">
<pre wrap="">On 3/23/06, Luke Vanderfluit <a class="moz-txt-link-rfc2396E" href="mailto:lvanderf@internode.com.au"><lvanderf@internode.com.au></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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
_______________________________________________
<a class="moz-txt-link-freetext" href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a>
Community help: <a class="moz-txt-link-freetext" href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a>
Commercial support: <a class="moz-txt-link-abbreviated" href="mailto:sales@bestpractical.com">sales@bestpractical.com</a>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at <a class="moz-txt-link-freetext" href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a>
We're hiring! Come hack Perl for Best Practical: <a class="moz-txt-link-freetext" href="http://bestpractical.com/about/jobs.html">http://bestpractical.com/about/jobs.html</a>
</pre>
</blockquote>
<pre wrap=""><!---->
--
Best regards, Ruslan.
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Luke
</pre>
</body>
</html>