Bug #16647
free form search is very slow, not excluding installed packages and applicable errata
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
Associated revisions
History
#1
Updated by The Foreman Bot over 4 years ago
- Status changed from New to Ready For Testing
- Pull request https://github.com/Katello/katello/pull/6338 added
#2
Updated by Lukas Zapletal over 4 years ago
Can you guys backport this into Katello 3.2? Small change, big impact.
#3
Updated by John Beranek over 4 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...
#4
Updated by Justin Sherrill over 4 years ago
- Status changed from Ready For Testing to Closed
- % Done changed from 0 to 100
Applied in changeset katello|cff2d2ca0bf8f8d51f9acbce1fc0d8a85ecc5cf2.
#5
Updated by Justin Sherrill over 4 years ago
- Legacy Backlogs Release (now unused) set to 162
#6
Updated by Chris Duryee over 4 years ago
- Bugzilla link set to 1380486
Fixes #16647 - restrict host freeform search to a few items (#6338)