Refactor #5936

Unnecessary call to FactName.maximum slows down ENC

Added by Daniel Lobato Garcia about 4 years ago. Updated 8 days ago.

Status:Closed
Priority:Normal
Assignee:Daniel Lobato Garcia
Category:External Nodes
Target version:1.5.1
Difficulty: Team Backlog:
Triaged: Fixed in Releases:
Bugzilla link:1107671 Found in Releases:
Pull request:

Description

As explained here: https://github.com/theforeman/foreman/pull/1477

The query "SELECT MAX AS maximum_id, name AS name FROM `fact_names` GROUP BY name ORDER BY fact_names.name" needs to be called only when there are facts to create. Calling it every time slows down every ENC call, especially when the fact_names table is large.

History

#1 Updated by Dominic Cleal about 4 years ago

  • Status changed from Assigned to Closed
  • % Done changed from 0 to 100
  • Legacy Backlogs Release (now unused) set to 16

#2 Updated by Bryan Kearney about 4 years ago

  • Bugzilla link set to https://bugzilla.redhat.com/show_bug.cgi?id=1107671

Also available in: Atom PDF