Note: This is a public test instance of Red Hat Bugzilla. The data contained within is a snapshot of the live data so any changes you make will not be reflected in the production Bugzilla. Email is disabled so feel free to test any aspect of the site that you want. File any problems you find or give feedback at
Bug 1098313 - The system details pages are slow for no reason if system has many virtual guests
Summary: The system details pages are slow for no reason if system has many virtual gu...
Alias: None
Product: Spacewalk
Classification: Community
Component: Server
Version: 2.2
Hardware: Unspecified
OS: Unspecified
Target Milestone: ---
Assignee: Stephen Herr
QA Contact: Red Hat Satellite QA List
Depends On:
Blocks: space22
TreeView+ depends on / blocked
Reported: 2014-05-15 18:46 UTC by Stephen Herr
Modified: 2014-07-17 08:41 UTC (History)
0 users

Fixed In Version: spacewalk-java-2.2.67
Doc Type: Bug Fix
Doc Text:
Clone Of:
Last Closed: 2014-07-17 08:41:22 UTC

Attachments (Terms of Use)

Description Stephen Herr 2014-05-15 18:46:26 UTC
Description of problem:
Any of the System Details pages are very slow for no good reason if the system happens to have many virtual guests (in my case, 2000, or at least 1 guest that has registered 2000 times). This is because to determine what icon to display next to the server name we have to see if the system is a virtual host, we are currently doing that by having Hibernate hydrate every guest and then returning "True" if the list of guests is larger than 0.

This is stupid, instead we should just have a query that returns a "1" or something if the server is a virtual host.

How reproducible:

Steps to Reproduce:
1. Register a host's guest several thousand times
2. navigate to Systems -> <system_name> -> <any of these pages>

Actual results:
Those pages are all very slow

Expected results:
They should be an appropriate speed and only load details for the guests if they actually need that information.

Comment 1 Stephen Herr 2014-05-15 20:54:07 UTC
Committed to Spacewalk master:

Comment 2 Stephen Herr 2014-05-19 12:49:35 UTC

Comment 3 Milan Zázrivec 2014-07-17 08:41:22 UTC
Spacewalk 2.2 has been released:

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