Bug 1419126

Summary: activation key page takes 10-20 seconds to load for each batch of keys
Product: Red Hat Satellite Reporter: Chris Duryee <cduryee>
Component: Activation KeysAssignee: Partha Aji <paji>
Status: CLOSED ERRATA QA Contact: jcallaha
Severity: medium Docs Contact:
Priority: high    
Version: 6.2.7CC: bbuckingham, bkearney, dcaplan, ehelms, jcallaha, jsherril, pcreech, pmoravec
Target Milestone: UnspecifiedKeywords: Performance, PrioBumpField, PrioBumpPM, Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2018-02-21 16:54:37 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
verification screenshot 1
none
verification screenshot 2 none

Description Chris Duryee 2017-02-03 16:13:39 UTC 
Description of problem:

If you go to the activation key page (content -> activation keys), it can take a long time for the page to load. It looks like two calls to candlepin are made for each key, each taking about 300msec.

Ideally, the number of calls to candlepin would not scale linearly with the number of activation keys.

If the activation key page could load each "page" of data in under 5 seconds, that would be much better.

Version-Release number of selected component (if applicable): 6.2.7


Steps to Reproduce:
1. create 20 or 30 activation keys
2. view AK page

Actual results: slow load time. I got 18 seconds locally but I've seen up to 45 seconds.


Expected results: 5 second load time or better
Comment 4 Brad Buckingham 2017-08-14 12:42:29 UTC 
Created redmine issue http://projects.theforeman.org/issues/20584 from this bug
Comment 5 Satellite Program 2017-08-17 18:15:37 UTC 
Upstream bug assigned to paji
Comment 8 Satellite Program 2017-09-25 14:15:31 UTC 
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/20584 has been resolved.
Comment 9 Justin Sherrill 2017-11-27 15:18:16 UTC 
Proposed for 6.3.0 since it is fixed upstream
Comment 11 jcallaha 2018-01-29 18:52:59 UTC 
Verified in Satellite 6.3 Snap 33.

The page load times have been reduced significantly. See below averages as well as the attached screenshots.

Load from other pages: 1.8s - 6.5s
Reload: 7s
Switching between paginated AK loads: 0.5 - 1.5s
Comment 12 jcallaha 2018-01-29 18:55:48 UTC 
Created attachment 1387951 [details]
verification screenshot 1
Comment 13 jcallaha 2018-01-29 18:56:30 UTC 
Created attachment 1387952 [details]
verification screenshot 2
Comment 14 Satellite Program 2018-02-21 16:54:37 UTC 
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA.
> > 
> > For information on the advisory, and where to find the updated files, follow the link below.
> > 
> > If the solution does not work for you, open a new bug report.
> > 
> > https://access.redhat.com/errata/RHSA-2018:0336