Bug 462245 - ChannelDetails.do is slow to display when many package are in channel
Summary: ChannelDetails.do is slow to display when many package are in channel
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Spacewalk
Classification: Community
Component: WebUI
Version: 0.2
Hardware: All
OS: Linux
medium
medium
Target Milestone: ---
Assignee: Jesus M. Rodriguez
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: space03
TreeView+ depends on / blocked
 
Reported: 2008-09-14 18:25 UTC by John Matthews
Modified: 2009-09-17 07:01 UTC (History)
1 user (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2009-09-17 07:01:43 UTC
Embargoed:


Attachments (Terms of Use)

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.


Note You need to log in before you can comment on or make changes to this bug.