#962 [HHQ-1830] Event Center performance with Time range filter

[Hyperic Team]

http://jira.hyperic.com/browse/HHQ-1830
Total number of events in eam_event_log = 2.1 million (spread randomly over past 30 days)

FilterName-----------------------------------------------------------------Load Time (seconds)


Default-----------------------------------------------------------------------2


Log=Info---------------------------------------------------------------------18


TimeRange=24hrs-------------------------------------------------------50


TimeRange=1wk---------------------------------------------------------356 (1 month would take forever to load)


TimeRange24hrs+Group containing 1500 resources---------38


TimeRange1wk+Group containing 1500 resources------------50

Attached is the query/plan for the filter that took most time above.