#1664 [HHQ-2156] Specific HQ internal SQL query performs poorly un

[Hyperic Team]

http://jira.hyperic.com/browse/HHQ-2156
This query (used in monitor window) is not optimized for MySQL due to the subquery:

SELECT i


FROM EAM_NUMBERS


WHERE i < 60


AND EXISTS


(


  SELECT id


  FROM EAM_EVENT_LOG


  WHERE timestamp BETWEEN (1211879633444 + (240000 * i)) AND


((1211879633444 + (240000 * (i + 1))) - 1)


  AND entity_id = 16706


  AND entity_type = 3 LIMIT 1


);