[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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110916/0496a995/attachment.htm>