Project

General

Profile

Actions
Copy link

Bug #36944

closed

all hosts page slow -> reduce the amout of queries to load the rex status

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

Status:
Closed
Priority:
High
Assignee:
Bernhard Suttner
Category:
-
Target version:
-
Difficulty:
Triaged:
No
Bugzilla link:
Pull request:
https://github.com/theforeman/foreman_remote_execution/pull/851
Fixed in Releases:
foreman_remote_execution-13.0.0
Found in Releases:
Red Hat JIRA:

Description

This line of code is responsible for 6 DB queries for each host: https://github.com/theforeman/foreman_remote_execution/blob/master/app/models/host_status/execution_status.rb#L112 and no preload/eager_loading is used. Means, if you have 100 hosts, it will run 600 DB queries.

This should be improved to improve the performance.

Actions
Copy link

Also available in: Atom PDF