Hi, Our RT3 system is a big and it crashes time to time. Today we found one query in the slow queries log which killed the system: * # Query_time: 97 Lock_time: 0 Rows_sent: 15906633 Rows_examined: 39069181 SELECT main.* FROM Transactions main WHERE (main.Type = 'Create' OR main.Type = 'Comment' OR main.Type = 'Correspond') ORDER BY main.Created ASC, main.id ASC; * Is there a way to reduce a number of returning records on the application level?
Thanks in advance. -- Cheers, Michael
-------- RT Training Sessions (http://bestpractical.com/services/training.html) * Chicago, IL, USA September 26 & 27, 2011 * San Francisco, CA, USA October 18 & 19, 2011 * Washington DC, USA October 31 & November 1, 2011 * Melbourne VIC, Australia November 28 & 29, 2011 * Barcelona, Spain November 28 & 29, 2011