Bug #16647: free form search is very slow, not excluding installed packages and applicable errata - Katello - Foreman

Bug #16647

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

Added by Justin Sherrill over 2 years ago. Updated 11 months ago.

Status:

Closed

Priority:

Normal

Assignee:

Justin Sherrill

Category:

Database

Target version:

Katello 3.2.0

Difficulty:

trivial

Triaged:

Bugzilla link:

1380486

Pull request:

https://github.com/Katello/katello/pull/6338

Team Backlog:

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

Associated revisions

Revision cff2d2ca (diff)
Added by Justin Sherrill over 2 years ago

Fixes #16647 - restrict host freeform search to a few items (#6338)

History

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

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

#3 Updated by John Beranek over 2 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...