Project

General

Custom queries

Profile

Actions

Bug #25624

closed

Registered hosts' report performs poorly

Added by Marek Hulán over 6 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Reporting
Target version:
-
Fixed in Releases:
Found in Releases:

Description

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1655628

Description of problem:
Performance testing shows that there's most likely something done inefficiently in the Registered hosts report. I've tested on a Satellite with 10 000 systems.

When running a report without filters, it takes 8 minutes (there are no performance requirements specified so this should be fine). However, when running with a host filter such that it limits hosts to only 500 of these 10 000, the report generation consistently fails with ISE after 30 minutes.

Tested on a RHEL7 machine with Intel Xeon, 4 sockets, 32 cores, hyperthreading, 2.7 Ghz, 128 GB RAM

Version-Release number of selected component (if applicable):
6.5 snap 5

How reproducible:
Deterministic on one machine but may be influenced by the machine's performance.

Steps to Reproduce:
1. Have a Satellite with 10 000 systems, 500 of them with some easily filterable name
2. Monitor -> Report Templates -> Registered Hosts -> Generate
3. Fill in a filter such that it selects 500 systems
4. Submit

Actual results:
ISE after 30 minutes

Expected results:
Report generated. I'd expect it to be faster than without the filter

Added by Marek Hulán over 6 years ago

Revision 8a76900b (diff)

Fixes #25624 - add explicit kernel release fact loader

The problem with registered hosts report is that for each host we load
all host facts just in order to display kernelrelease fact value. We
can define explicit association for this fact so we can `:include` it.
To use it in templates a new macro `host_kernel_release` is introduced.

Added by Marek Hulán over 6 years ago

Revision 697b949f (diff)

Refs #25624 - improve performance for registered hosts

Actions

Also available in: Atom PDF