Hi,<br><br>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:<br><tt><b><i><br>
# Query_time: 97 Lock_time: 0 Rows_sent: 15906633
Rows_examined: 39069181<br>
SELECT main.* FROM Transactions main WHERE (main.Type =
'Create' OR main.Type = 'Comment' OR main.Type =
'Correspond') ORDER BY main.Created ASC, <a href="http://main.id">main.id</a> ASC;<br>
</i></b></tt><br>Is there a way to reduce a number of returning records on the application level? <br><br>Thanks in advance.<br clear="all"><br>-- <br>Cheers,<br>Michael<br>