[rt-users] How to avoid a huge dataset returning

[Michael Stepanov]

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