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
-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf
Of Uli Staerk
Sent: Monday, August 13, 2007 6:38 AM
To: rt-users@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…
Marlier, Ian schrieb:
-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf
Of Uli Staerk
Sent: Monday, August 13, 2007 6:38 AM
To: rt-users@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…
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.
Tobias