Project

General

Profile

Actions
Copy link

Bug #17196

closed

Add indexes to the host_salt_modules and hostgroup_salt_modules tables

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

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

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 open — 0 closed)

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

Also available in: Atom PDF