Bug #16647
closed
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
Updated by The Foreman Bot over 8 years ago
- Status changed from New to Ready For Testing
- Pull request https://github.com/Katello/katello/pull/6338 added
Updated by Lukas Zapletal over 8 years ago
Can you guys backport this into Katello 3.2? Small change, big impact.
Updated by John Beranek over 8 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...
Updated by Justin Sherrill over 8 years ago
- Status changed from Ready For Testing to Closed
- % Done changed from 0 to 100
Applied in changeset katello|cff2d2ca0bf8f8d51f9acbce1fc0d8a85ecc5cf2.
Updated by Justin Sherrill over 8 years ago
- Translation missing: en.field_release set to 162
Updated by