[rt-users] query drastically slowing down RT

[Glyn Davies]

Hi Folks,

I have problems with a couple of user generated queries that drastically
slow down the RT database.

The database is MySQL 5 running on a separate server from RT ( 4.0.5 )

The queries in question are of a similar format to the following,

Queue = 'Solutions'
AND (  Status = 'new' OR Status = 'open' )
AND (  Requestor.EmailAddress = 'user1 at site.net.nz' OR
Requestor.EmailAddress = 'user2 at site.net.nz' OR Requestor.EmailAddress = '
user3 at site.net.nz' OR Requestor.EmailAddress = 'user4 at site.net.nz' OR
Requestor.EmailAddress = 'user5 at site.net.nz' OR Requestor.EmailAddress = '
user6 at site.net.nz' OR Requestor.EmailAddress = 'user7 at site.net.nz' )

With only a few email addresses entered the query runs in an acceptable
time, however as the number increase the query almost forces the database
to a standstill.

Does anyone have any ideas on how I can make any improvements on
performance?

Thanks in advance.

Cheers,
Glyn
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120430/c34ef789/attachment.htm>