Project

General

Profile

Actions

Bug #16647

closed

free form search is very slow, not excluding installed packages and applicable errata

Added by Justin Sherrill over 7 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Normal
Category:
-
Target version:
Difficulty:
trivial
Triaged:
Fixed in Releases:
Found in Releases:

Description

Currently the free form search: 'foo' is very slow. it is very fast when specifying the fields (bar=foo). This is due to some fields that are not excluded which should be from the unscoped search

Topic discussed here: https://groups.google.com/forum/#!topic/foreman-users/akKzfe23udw

Actions #1

Updated by The Foreman Bot over 7 years ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/Katello/katello/pull/6338 added
Actions #2

Updated by Lukas Zapletal over 7 years ago

Can you guys backport this into Katello 3.2? Small change, big impact.

Actions #3

Updated by John Beranek over 7 years ago

Glad I found this issue, as we're experiencing this slowdown too, and I was going to raise an issue if I didn't find an existing one.

For us, we have just 212 content hosts, and a search for something like "pal*" in order to get a subset of hosts (something you can't do with the field search?) takes around 21s.

As a side note, a similar search in the "All Hosts" page is also pretty slow:

https://katello.example.com/hosts?utf8=%E2%9C%93&search=pal*

takes around 18s...

Actions #4

Updated by Justin Sherrill over 7 years ago

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

Updated by Justin Sherrill over 7 years ago

  • translation missing: en.field_release set to 162
Actions #6

Updated by Chris Duryee over 7 years ago

  • Bugzilla link set to 1380486
Actions

Also available in: Atom PDF