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

Updated by The Foreman Bot over 1 year ago

  • Status changed from New to Ready For Testing
  • Assignee set to Bernhard Suttner
  • Pull request https://github.com/theforeman/foreman_remote_execution/pull/851 added
Actions
Copy link
 #2

Updated by The Foreman Bot about 1 year ago

  • Fixed in Releases foreman_remote_execution-12.0.3 added
Actions
Copy link
 #3

Updated by Anonymous about 1 year ago

  • Status changed from Ready For Testing to Closed
Actions
Copy link
 #4

Updated by Adam Ruzicka about 1 year ago

  • Fixed in Releases foreman_remote_execution-13.0.0 added
  • Fixed in Releases deleted (foreman_remote_execution-12.0.3)
Actions
Copy link

Also available in: Atom PDF