Bug #31764
closed
available_for content_view_version parameter to /katello/api/packages or /katello/api/errata is slow
Added by Paul Donohue almost 4 years ago.
Updated over 3 years ago.
Description
I wrote the original implementations for "available_for" in commits c874ec9f6a and f38cc3f447. Unfortunately, that implementation is extremely slow/inefficient when working with large numbers of packages/errata.
A more efficient implementation is possible and should be implemented.
- Status changed from New to Ready For Testing
- Assignee set to Paul Donohue
- Pull request https://github.com/Katello/katello/pull/9130 added
New implementation reduces the SQL query time for one particular use case on a production installation from about 5 minutes to about 5 seconds.
- Triaged changed from Yes to No
- Category set to Content Views
- Target version set to Katello 4.1.0
- Triaged changed from No to Yes
- Triaged changed from Yes to No
- Target version changed from Katello 4.1.0 to Katello 4.1.1
- Triaged changed from No to Yes
- Fixed in Releases Katello 4.2.0 added
- Status changed from Ready For Testing to Closed
Also available in: Atom
PDF