Project

General

Profile

Bug #16647

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

Added by Justin Sherrill almost 3 years ago. Updated about 1 year ago.

Status:
Closed
Priority:
Normal
Category:
Database
Target version:
Difficulty:
trivial
Triaged:
Bugzilla link:
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 almost 3 years ago

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

History

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

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

#3 Updated by John Beranek almost 3 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 almost 3 years ago

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

#5 Updated by Justin Sherrill almost 3 years ago

  • Legacy Backlogs Release (now unused) set to 162

#6 Updated by Chris Duryee almost 3 years ago

  • Bugzilla link set to 1380486

Also available in: Atom PDF