Marlier, Ian schrieb:
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Uli Staerk
Sent: Monday, August 13, 2007 6:38 AM
To: [email protected]
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
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
