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 = '[email protected]' OR Requestor.EmailAddress = '[email protected]' OR Requestor.EmailAddress = ' [email protected]' OR Requestor.EmailAddress = '[email protected]' OR Requestor.EmailAddress = '[email protected]' OR Requestor.EmailAddress = ' [email protected]' OR Requestor.EmailAddress = '[email protected]' ) 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
