Bug 1196673
Summary: | task list page is very slow | ||
---|---|---|---|
Product: | Red Hat Satellite | Reporter: | Peter Vreman <peter.vreman> |
Component: | Tasks Plugin | Assignee: | Chris Duryee <cduryee> |
Status: | CLOSED ERRATA | QA Contact: | Jitendra Yejare <jyejare> |
Severity: | medium | Docs Contact: | |
Priority: | unspecified | ||
Version: | 6.0.8 | CC: | bbuckingham, bkearney, cduryee, cwelton, tspeetje, xdmoon |
Target Milestone: | Unspecified | Keywords: | Performance, 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-07-27 09:13:51 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 |
Description
Peter Vreman
2015-02-26 13:57:19 UTC
Since this issue was entered in Red Hat Bugzilla, the release flag has been set to ? to ensure that it is properly evaluated for this release. I tested the speed of the tasks page on Satellite 6.1 and 6.2 (snapshot version): on 6.1: /foreman_tasks/tasks for 96 tasks, pagination of 20 takes 4692ms /foreman_tasks/tasks for 96 tasks, pagination of 10,000 takes 15426ms on 6.2: /foreman_tasks/tasks for 2035 tasks, pagination of 20 takes 1103ms /foreman_tasks/tasks for 2035 tasks, pagination of 10,000 takes 53606ms I saw similar improvement on a Katello 2.4 installation with >3000 tasks, pagination of 20. I am investigating more now to see what caused the improvement. This appears to be addressed via an index that was added to the DB. Peter, I believe this bug was addressed by adding an index to the tasks table, which sped things up significantly. I think this makes the dropdown with default of 24h not needed anymore, but if you disagree please reply back to this BZ. Thanks! Verified ! @ Sat 6.2 Snap 9.2 I tested this with 4493 tasks in 225 pages with 20 entries per page. Its loading the tasks in expected/reasonable time. So, moving the bz to verified. Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHBA-2016:1501 |