Project

General

Custom queries

Profile

Actions

Bug #31764

closed

available_for content_view_version parameter to /katello/api/packages or /katello/api/errata is slow

Added by Paul Donohue over 4 years ago. Updated almost 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Content Views
Target version:
Difficulty:
Triaged:
Yes
Fixed in Releases:
Found in Releases:

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 #2

Updated by Paul Donohue over 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 #8

Updated by Anonymous almost 4 years ago

  • Status changed from Ready For Testing to Closed
Actions

Also available in: Atom PDF