Project

General

Profile

Actions
Copy link

Bug #36941

closed

all hosts page slow -> reduce the amount of katello host tracer queries

Added by Bernhard Suttner about 1 year ago. Updated about 1 year ago.

Status:
Closed
Priority:
Normal
Assignee:
Bernhard Suttner
Category:
Hosts
Target version:
Katello 4.12.0
Difficulty:
Triaged:
Yes
Bugzilla link:
Pull request:
https://github.com/Katello/katello/pull/10809
Fixed in Releases:
Katello 4.12.0
Found in Releases:
Red Hat JIRA:

Description

we recognized, that the all hosts page is somehow slow. after some research, we found out, that a lot of data is loaded from other db tables.
like katello host tracers, installed packages, katello_content_facet_errata.

for each host, one or more db queries are executed. we should get rid of this n+1 queries.

Actions
Copy link

Also available in: Atom PDF