#1438 [HHQ-2036] Resource monitor page loads slow as event logs gr

[Hyperic Team]

http://jira.hyperic.com/browse/HHQ-2036
I see following query every time I visit resource monitor page. I believe this gets the number for log events for the 0-60 timeline.


The test setup has ~500K event logs.

Not sure if the query is still the same in 4.0 with resource hierarchy changes.

Time: 080430 17:23:28

User@Host: hqadmin[hqadmin] @ [10.0.0.122]

Query_time: 35 Lock_time: 0 Rows_sent: 16 Rows_examined: 30664660

SELECT i FROM EAM_NUMBERS WHERE i < 60 AND EXISTS (SELECT id FROM EAM_EVENT_LOG WHERE timestamp BETWEEN (1209572573882 + (480000 * i)) AND ((1209572573882 + (480000 * (i + 1))) - 1) AND entity_id = 11704 AND entity_type = 1 LIMIT 1);