Bug 1161636

Summary:	Content View Versions page takes a long time to list
Product:	Red Hat Satellite	Reporter:	Justin Sherrill <jsherril>
Component:	API	Assignee:	Justin Sherrill <jsherril>
Status:	CLOSED ERRATA	QA Contact:	Kedar Bidarkar <kbidarka>
Severity:	high	Docs Contact:
Priority:	unspecified
Version:	6.0.8	CC:	bbuckingham, bkearney, cwelton, jaudet, jmontleo, kbidarka, mmccune, pcfe
Target Milestone:	Unspecified	Keywords:	Triaged
Target Release:	Unused
Hardware:	Unspecified
OS:	Unspecified
URL:	http://projects.theforeman.org/issues/8491
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:
Clones:	1167417 (view as bug list)		Environment:
Last Closed:	2015-02-20 18:32:10 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:
Bug Depends On:
Bug Blocks:	1122832, 1167417

Description Justin Sherrill 2014-11-07 14:29:34 UTC

Description of problem:

Having a lot of content view versions of a single content view (~55), each with ~4 repositories totaly 25,000 packages and 50 puppet modules causes the content view versions list to take 2-3 minutes to load


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

How reproducible:
Always

Steps to Reproduce:
1.  Load up a content view with 55 versions of the amount of data mentioned above
2.  Navigate to Content Views > MyView  and wait for the versions list to show


Actual results:
takes 2 -3 minutes

Expected results:
takes ~10 seconds or less


Additional info:

Comment 3 Justin Sherrill 2014-11-21 15:20:55 UTC

Reproduced by adding ~100 puppet modules to a content view and published ~30 times.

Comment 4 Justin Sherrill 2014-11-24 16:51:38 UTC

Created redmine issue http://projects.theforeman.org/issues/8491 from this bug

Comment 5 Bryan Kearney 2014-12-09 15:04:51 UTC

Moving to POST since upstream bug http://projects.theforeman.org/issues/8491 has been closed
-------------
Justin Sherrill
Applied in changeset commit:katello|1ced1c519b6dee549634d81536a6558b66dd88f7.

Comment 9 Bryan Kearney 2015-02-05 21:04:46 UTC

Moving to POST since upstream bug http://projects.theforeman.org/issues/8491 has been closed
-------------
Justin Sherrill
Applied in changeset commit:katello|1ced1c519b6dee549634d81536a6558b66dd88f7.

Comment 12 Kedar Bidarkar 2015-02-12 14:10:38 UTC

Added 8000 packages and 18 puppet-modules to a Content-View and published this content-view 33 times.

The page now opens up in ~15 secs. 

VERIFIED With Sat6.0.8 build.

Comment 13 jaudet 2015-02-12 18:43:57 UTC

This bug is not 100% fixed 

> Expected results:
> takes ~10 seconds or less

However, the results are significantly better than the 2-3 minute wait described in the bug. I double-checked kbidarka's results and did some additional tests of my own. Here's the results:

* ~18 seconds: Content view with 8090 packages and 33 versions. Installed on RHEL 6.6
* ~30-45 seconds: Content view with 5639 packages (250 errata) and 40 versions. Installed on RHEL 7.0.

Some of those differences in timing may arise from differences in underlying hardware, too.

Related to: https://bugzilla.redhat.com/show_bug.cgi?id=1192162

Comment 15 errata-xmlrpc 2015-02-20 18:32:10 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/RHBA-2015:0247