Project

General

Profile

Bug #16893

host collection dashboard widget slows down as errata count grows

Added by Chris Duryee over 2 years ago. Updated 11 months ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Dashboard
Target version:
Difficulty:
Triaged:
Yes
Bugzilla link:
Team Backlog:
Fixed in Releases:
Found in Releases:

Description

The host collection dashboard widget gets slower and slower as the number of errata grows. If there are 500K errata applicable in a large host collection, it can take upwards of 50 seconds to render.

It appears that there are some areas that find critical and non-critical errata by looping over all the errata in code, instead of via db calls.

Associated revisions

Revision 7e43272b (diff)
Added by Chris Duryee over 2 years ago

Fixes #16893 - rely on DB to determine errata type in collection

Previously, the errata checks in host collections would iterate over
all errata in memory to determine if any errata were critical. If there
were a lot of errata to iterate over (say, over 500K), this could take
nearly a minute and force passenger to consume lots of CPU.

This patch alters this behavior so a DB query is used, times appear to
be sub-second now.

History

#1 Updated by The Foreman Bot over 2 years ago

  • Status changed from Assigned to Ready For Testing
  • Pull request https://github.com/Katello/katello/pull/6392 added

#2 Updated by Chris Duryee over 2 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100

#3 Updated by Eric Helms over 2 years ago

  • Legacy Backlogs Release (now unused) set to 162

Also available in: Atom PDF