Project

General

Profile

Actions

Bug #36941

closed

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

Added by Bernhard Suttner 11 months ago. Updated 10 months ago.

Status:
Closed
Priority:
Normal
Category:
Hosts
Target version:
Difficulty:
Triaged:
Yes
Fixed in Releases:
Found in Releases:

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 #1

Updated by The Foreman Bot 11 months ago

  • Status changed from New to Ready For Testing
  • Assignee set to Bernhard Suttner
  • Pull request https://github.com/Katello/katello/pull/10809 added
Actions #2

Updated by Quinn James 10 months ago

  • Category set to Hosts
  • Target version set to Katello 4.12.0
  • Triaged changed from No to Yes
Actions #3

Updated by The Foreman Bot 10 months ago

  • Fixed in Releases Katello 4.12.0 added
Actions #4

Updated by Anonymous 10 months ago

  • Status changed from Ready For Testing to Closed
Actions

Also available in: Atom PDF