[rt-users] extremely slow rt response, query hanging

[Ruslan Zakirov]

On 12/8/05, Stephen Turner <sturner at mit.edu> wrote:
> At Wednesday 12/7/2005 03:54 AM, Harald Wagener wrote:
> >Hello,
> >One of our users constructed a search on our RT 3.2.2 instance which
> >is slowing the system down quite a lot:
> >
> >SELECT COUNT(DISTINCT main.id) FROM Tickets main , Transactions
> >Transactions_1, Attachments Attachments_2  WHERE ((main.EffectiveId =
> >main.id)) AND ((main.Status != 'deleted')) AND ((main.Type =
> >'ticket')) AND ((main.Subject LIKE '%Performance%')OR
> >( (Attachments_2.Content LIKE '%Performance%')AND
> >(Attachments_2.TransactionId = Transactions_1.id)AND(main.id =
> >Transactions_1.Ticket) ) )
>
> For what it's worth, we've experienced this when searching on Subject &
> Content together (RT 3.4.2, Oracle 9). Either a subject search or a content
> search is OK, but not both together. I haven't had time to profile the
> query, so I can't shed any light on a solution.
Random guess is that when you add two conditions then DB have to use
temporary table.

>
> Steve
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>
> Download a free sample chapter of RT Essentials from O'Reilly Media at http://rtbook.bestpractical.com
>
> WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
> San Francisco - Find out more at http://bestpractical.com/services/training.html
>


--
Best regards, Ruslan.