[rt-users] query drastically slowing down RT

2012-04-29 Thread 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

Re: [rt-users] query drastically slowing down RT

2012-04-29 Thread Jeff Fearn
On 04/30/2012 10:23 AM, Glyn Davies wrote: 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,