Bug #17196

Add indexes to the host_salt_modules and hostgroup_salt_modules tables

Added by Tomer Brisker 7 months ago. Updated 6 months ago.

Status:Closed
Priority:Normal
Assigned To:Tomer Brisker
Category:-
Target version:Foreman - Team Daniel - iteration 6
Difficulty:easy Pull request:https://github.com/theforeman/foreman_salt/pull/63
Bugzilla link:

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 6 months ago

Fixes #17196 - Add indexes on the join tables

History

#1 Updated by The Foreman Bot 7 months ago

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

#2 Updated by Tomer Brisker 7 months ago

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

#3 Updated by Daniel Lobato Garcia 7 months ago

  • Target version set to Team Daniel - iteration 3

#4 Updated by Anonymous 6 months ago

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

#5 Updated by Daniel Lobato Garcia 6 months ago

  • Target version changed from Team Daniel - iteration 3 to Team Daniel - iteration 6

Also available in: Atom PDF