Project

General

Profile

Actions

Bug #17196

closed

Add indexes to the host_salt_modules and hostgroup_salt_modules tables

Added by Tomer Brisker over 7 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
-
Target version:
Difficulty:
easy
Triaged:
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 1 (1 open0 closed)

Related to Foreman - Bug #17143: Performance degradation in "non-targeted" search through WebUI or APINew10/31/2016Actions
Actions #1

Updated by The Foreman Bot over 7 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
Actions #2

Updated by Tomer Brisker over 7 years ago

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

Updated by Daniel Lobato Garcia over 7 years ago

  • Target version set to 1.5.2
Actions #4

Updated by Anonymous over 7 years ago

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

Updated by Daniel Lobato Garcia over 7 years ago

  • Target version changed from 1.5.2 to 1.4.3
Actions

Also available in: Atom PDF