[rt-users] Query taking 30 minutes and more

[Tobias Heinz]

Marlier, Ian schrieb:
>  
>
>   
>> -----Original Message-----
>> From: rt-users-bounces at lists.bestpractical.com 
>> [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf 
>> Of Uli Staerk
>> Sent: Monday, August 13, 2007 6:38 AM
>> To: rt-users at lists.bestpractical.com
>> Subject: [rt-users] Query taking 30 minutes and more
>>
>> When I run the following query:
>> Content LIKE 'schäfer'
>> OR Subject LIKE 'schäfer'
>> OR Subject LIKE 'tekom'
>> OR Content LIKE 'tekom'
>> OR Requestor.EmailAddress LIKE 'tekom'
>> OR Requestor.EmailAddress LIKE 'schaefer'
>> OR Subject LIKE 'schaefer'
>> OR Content LIKE 'schaefer'
>> OR Requestor.Name LIKE 'schaefer'
>> OR Requestor.Name LIKE 'schäfer'
>>
>> This Query takes (currently) 30 Minutes and I'm still 
>> waiting. Can anyone reproduce this problem? I'm using RT 3.4.5
>>     
>
> I had occasional problems like that with 3.4.5, and never did find a solution.  Upgrading to RT 3.6 cleared them up.  It might be worth looking into....
>
> Not immediately helpful, but...
>
> - Ian
> _______________________________________________
>   
In my 3.4 it helped to add an index on the user table / username. With 
each incoming mail address creating a new (unpriviledged) user, the user 
table grows quickly and the index speeds up searches containing the 
Requestor a lot.

- hope this helps

Tobias