Bug #31764
available_for content_view_version parameter to /katello/api/packages or /katello/api/errata is slow
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.
Associated revisions
History
#1
Updated by The Foreman Bot over 1 year ago
- Assignee set to Paul Donohue
- Status changed from New to Ready For Testing
- Pull request https://github.com/Katello/katello/pull/9130 added
#2
Updated by Paul Donohue over 1 year ago
New implementation reduces the SQL query time for one particular use case on a production installation from about 5 minutes to about 5 seconds.
#3
Updated by Jonathon Turel over 1 year ago
- Triaged changed from Yes to No
#4
Updated by Jonathon Turel about 1 year ago
- Triaged changed from No to Yes
- Target version set to Katello 4.1.0
- Category set to Content Views
#5
Updated by Jeremy Lenz 12 months ago
- Triaged changed from Yes to No
#7
Updated by The Foreman Bot 11 months ago
- Fixed in Releases Katello 4.2.0 added
#8
Updated by Anonymous 11 months ago
- Status changed from Ready For Testing to Closed
Applied in changeset katello|006ecc75bc264c42b0b3052d1843bb661a6242db.
Fixes #31764 - Fix performance issues with available_for