Bug #17196

Add indexes to the host_salt_modules and hostgroup_salt_modules tables

Added by Tomer Brisker over 1 year ago. Updated 6 days ago.

Status:Closed
Priority:Normal
Assignee:Tomer Brisker
Category:-
Target version:1.4.3
Difficulty:easy Team Backlog:
Triaged: Fixed in Releases:
Bugzilla link: Found in Releases:
Pull request:https://github.com/theforeman/foreman_salt/pull/63

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 ... New 10/31/2016

Associated revisions

Revision dbbc9db4
Added by Tomer Brisker over 1 year ago

Fixes #17196 - Add indexes on the join tables

History

#1 Updated by The Foreman Bot over 1 year 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 over 1 year ago

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

#3 Updated by Daniel Lobato Garcia over 1 year ago

  • Target version set to 1.5.2

#4 Updated by Anonymous over 1 year ago

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

#5 Updated by Daniel Lobato Garcia over 1 year ago

  • Target version changed from 1.5.2 to 1.4.3

Also available in: Atom PDF