Bug 1411883

Summary: Poor UI performance in the global region for services: viewing the list of services
Product: Red Hat CloudForms Management Engine Reporter: Satoe Imaishi <simaishi>
Component: PerformanceAssignee: Nick LaMuro <nlamuro>
Status: CLOSED CURRENTRELEASE QA Contact: Pradeep Kumar Surisetty <psuriset>
Severity: high Docs Contact:
Priority: high    
Version: 5.6.0CC: arcsharm, cpelland, dajohnso, dmetzger, fdewaley, gtanzill, hkataria, jhardy, jocarter, mpovolny, obarenbo, pmukhedk, simaishi
Target Milestone: GAKeywords: ZStream
Target Release: 5.7.2   
Hardware: All   
OS: All   
Whiteboard: perf:service:distributed
Fixed In Version: 5.7.1.0 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: 1405436 Environment:
Last Closed: 2017-04-11 13:50:09 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: 1405436    
Bug Blocks:    

Comment 2 CFME Bot 2017-01-10 17:30:49 UTC 
New commit detected on ManageIQ/manageiq/euwe:
https://github.com/ManageIQ/manageiq/commit/ca34e404e4d911084da5e20e7c8d61fc49cf75cd

commit ca34e404e4d911084da5e20e7c8d61fc49cf75cd
Author:     Jason Frey <fryguy9>
AuthorDate: Tue Dec 13 20:45:50 2016 -0500
Commit:     Satoe Imaishi <simaishi>
CommitDate: Tue Jan 10 12:27:19 2017 -0500

    Merge pull request #11502 from NickLaMuro/sqlize_service_aggregation_virtual_cols
    
    Update Service Aggregation Methods to use SQL
    (cherry picked from commit bbe42e02017aa9a9a16c1e52a318daafb3a7a7b7)
    
    https://bugzilla.redhat.com/show_bug.cgi?id=1411883
    https://bugzilla.redhat.com/show_bug.cgi?id=1411887

 app/controllers/application_controller.rb |   4 +-
 app/controllers/service_controller.rb     |   9 +
 app/models/service/aggregation.rb         | 280 ++++++++++++++++++++++++++++--
 3 files changed, 279 insertions(+), 14 deletions(-)
Comment 3 Nick LaMuro 2017-01-30 21:06:25 UTC 
Backported in the above commit.