Actions
Bug #16238
closed
dashboard widget for latests events can be exteramlly slow
Description
when having many hosts, the latest event widget can take around a minute to load.
the line in question is most likely the issue:
def latest_events
# 9 reports + header fits the events box nicely...
@latest_events ||= ConfigReport.authorized(:view_config_reports).my_reports.interesting.where(:host_id => hosts.pluck(:id)).search_for('reported > "7 days ago"').limit(9).includes(:host)
end
Updated by Ohad Levy over 8 years ago
just changing the query to inner query, saved about 70% of the load time, yet its far from being optimal.
@latest_events ||= ConfigReport.authorized(:view_config_reports).my_reports.interesting.where(:host => hosts.reorder('')).search_for('reported > "7 days ago"').limit(9).includes(:host)
Updated by
Updated by Ohad Levy over 8 years ago
- Status changed from Ready For Testing to Closed
- % Done changed from 0 to 100
Applied in changeset 95fd95eaf0df8756b049dcaf993b4d9709d86401.
Updated by Dominic Cleal over 8 years ago
Release set to 1.12.3
Reverted again in 1.12.4 due to too many regressions, and the severe impact of errors on the dashboard. The change remains in 1.13.0 at this time as the errors (e.g. #16704) are more limited.
Actions