Project

General

Profile

Actions
Copy link

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.

Status:
Closed
Priority:
Normal
Assignee:
Paul Donohue
Category:
Content Views
Target version:
Katello 4.1.1
Difficulty:
Triaged:
Yes
Bugzilla link:
Pull request:
https://github.com/Katello/katello/pull/9130
Fixed in Releases:
Katello 4.2.0
Found in Releases:
Red Hat JIRA:

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.

Actions
Copy link
 #1

Updated by The Foreman Bot almost 4 years ago

  • Status changed from New to Ready For Testing
  • Assignee set to Paul Donohue
  • Pull request https://github.com/Katello/katello/pull/9130 added
Actions
Copy link
 #2

Updated by Paul Donohue almost 4 years 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.

Actions
Copy link
 #3

Updated by Jonathon Turel almost 4 years ago

  • Triaged changed from Yes to No
Actions
Copy link
 #4

Updated by Jonathon Turel over 3 years ago

  • Category set to Content Views
  • Target version set to Katello 4.1.0
  • Triaged changed from No to Yes
Actions
Copy link
 #5

Updated by Jeremy Lenz over 3 years ago

  • Triaged changed from Yes to No
Actions
Copy link
 #6

Updated by Samir Jha over 3 years ago

  • Target version changed from Katello 4.1.0 to Katello 4.1.1
  • Triaged changed from No to Yes
Actions
Copy link
 #7

Updated by The Foreman Bot over 3 years ago

  • Fixed in Releases Katello 4.2.0 added
Actions
Copy link
 #8

Updated by Anonymous over 3 years ago

  • Status changed from Ready For Testing to Closed
Actions
Copy link

Also available in: Atom PDF