Bug 462245

Summary: ChannelDetails.do is slow to display when many package are in channel
Product: [Community] Spacewalk Reporter: John Matthews <jmatthew>
Component: WebUIAssignee: Jesus M. Rodriguez <jesusr>
Status: CLOSED CURRENTRELEASE QA Contact: Red Hat Satellite QA List <satqe-list>
Severity: medium Docs Contact:
Priority: medium    
Version: 0.2CC: bbuckingham
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2009-09-17 07:01:43 UTC Type: ---
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: 456551    

Description John Matthews 2008-09-14 18:25:12 UTC
Description of problem:

Display channel details is slow on channels with many packages.  With a fedora9 channel with around 9000 packages I'm seeing the channel details page take minutes to display.  Example when running over VPN this is taking over 5 minutes to display.  When running with a local DB connection it's taking over 1 minute to display.

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

How reproducible:
Always

Steps to Reproduce:
1. Create a custom channel with over 9000 packages
2. View channel details, ChannelDetails.do
3. 
  
Actual results:
With a local connection it takes about a minute or more to load

Expected results:
Should load quicker

Additional info:
I think this might be slow because of the below line in ChannelDetailsAction.java:

request.setAttribute("pack_size", chan.getPackages().size());

Comment 1 John Matthews 2008-09-18 15:07:38 UTC
Justin addressed this with commit:

http://git.fedoraproject.org/git/?p=spacewalk.git;a=commitdiff;h=f78241a84cac7b5cca0a9cb66b9cbd167df2313f

This is in 'master' and will be part of sw 0.3

Comment 2 Brad Buckingham 2008-11-05 14:23:12 UTC
Verified on spacewalk-java-0.3.7-1.el5.sw.

Loading of channel details for F9 channel with 12K+ packages took less than 1 minute.

Comment 3 Miroslav Suchý 2009-09-17 07:01:43 UTC
Spacewalk has been released for some time.