Project

General

Profile

Bug #17196

Add indexes to the host_salt_modules and hostgroup_salt_modules tables

Added by Tomer Brisker almost 6 years ago. Updated about 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
-
Target version:
Difficulty:
easy
Triaged:
Bugzilla link:
Fixed in Releases:
Found in Releases:

Description

Currently there are no indexes, leading to any join using those join tables to scan the entire table instead of only the indexes. See http://projects.theforeman.org/issues/17143 for an example.


Related issues

Related to Foreman - Bug #17143: Performance degradation in "non-targeted" search through WebUI or APINew2016-10-31

Associated revisions

Revision dbbc9db4 (diff)
Added by Tomer Brisker almost 6 years ago

Fixes #17196 - Add indexes on the join tables

History

#1 Updated by The Foreman Bot almost 6 years ago

  • Status changed from New to Ready For Testing
  • Assignee set to Tomer Brisker
  • Pull request https://github.com/theforeman/foreman_salt/pull/63 added

#2 Updated by Tomer Brisker almost 6 years ago

  • Related to Bug #17143: Performance degradation in "non-targeted" search through WebUI or API added

#3 Updated by Daniel Lobato Garcia almost 6 years ago

  • Target version set to 1.5.2

#4 Updated by Anonymous almost 6 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100

#5 Updated by Daniel Lobato Garcia almost 6 years ago

  • Target version changed from 1.5.2 to 1.4.3

Also available in: Atom PDF