Bug 1271160
Summary: | API Listing products slow, 36 products takes 50+ seconds | ||||||
---|---|---|---|---|---|---|---|
Product: | Red Hat Satellite | Reporter: | Peter Vreman <peter.vreman> | ||||
Component: | Performance | Assignee: | Adam Price <adprice> | ||||
Status: | CLOSED DUPLICATE | QA Contact: | |||||
Severity: | medium | Docs Contact: | |||||
Priority: | unspecified | ||||||
Version: | 6.1.2 | CC: | bbuckingham, bkearney, cduryee, peter.vreman, sthirugn | ||||
Target Milestone: | Unspecified | Keywords: | Triaged | ||||
Target Release: | Unused | ||||||
Hardware: | Unspecified | ||||||
OS: | Unspecified | ||||||
Whiteboard: | |||||||
Fixed In Version: | Doc Type: | Bug Fix | |||||
Doc Text: | Story Points: | --- | |||||
Clone Of: | Environment: | ||||||
Last Closed: | 2016-05-26 18:28:58 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 | ||||||
Attachments: |
|
Description
Peter Vreman
2015-10-13 09:43:55 UTC
Sync plans are not used, as mentioned in the a related BZ1253802 Created attachment 1082314 [details]
products index response
I get about 100ms per product when making a similar call, on both Satellite 6.1 (katello 2.2) and Katello 3.0. For example, 134 products takes 10 seconds, and on a different machine, 126 products takes 13 seconds. Can you confirm that this is still happening, and also that the system load is not high? clearing needsinfo, I was able to repro this after enabling repos on products. I was not able to reproduce this issue this on 6.2, I believe my other test was flawed since it was on a development VM. How I tested: * in one org, create 10 products with 10 repos each (100 repo total). Sync all repos a few times, to create a basis of prior syncs that will be reported in the product call. * in same org, import manifest and enable 43 repos across various products. Sync all 143 repos. After this, I get about 12-16 seconds per call to list all 122 products. When enabling pagination, the time goes down significantly. I believe the 12-16 second number is the time it takes to render the JSON output, given that the activerecord time is low. The 12-16 for 143 repos on 10 products does not meet the <5 seconds without pagination. For automation processes to do things frequently having 16sec is still not good enough. E.g. in a Continuous Intergration process to having 10x 15sec delays is 150 seconds = 2,5 minutes just to list data. Like mentioned the 'complex' activerecord is quick, but the rendering is slow. Then this rendering process needs to be looked how it can be improved. needing 10seconds to output JSON from data already in memory is not good. *** This bug has been marked as a duplicate of bug 1330307 *** |