Bug 657107
Summary: | need to make alert query more efficient for "recent alert count" display | ||
---|---|---|---|
Product: | [Other] RHQ Project | Reporter: | John Mazzitelli <mazz> |
Component: | Core UI | Assignee: | Charles Crouch <ccrouch> |
Status: | CLOSED CURRENTRELEASE | QA Contact: | Mike Foley <mfoley> |
Severity: | low | Docs Contact: | |
Priority: | low | ||
Version: | 3.0.0 | CC: | ccrouch, hbrock |
Target Milestone: | --- | ||
Target Release: | --- | ||
Hardware: | Unspecified | ||
OS: | Unspecified | ||
Whiteboard: | |||
Fixed In Version: | Doc Type: | Bug Fix | |
Doc Text: | Story Points: | --- | |
Clone Of: | Environment: | ||
Last Closed: | 2013-09-02 07:14:01 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: |
Description
John Mazzitelli
2010-11-24 22:50:17 UTC
looks like the criteria uses limits the page size to 1 row, so this isn't as bad as it first looked by code inspection. // only get one record from the first page, we only really care about the count alertCriteria.setPaging(0, 1); But we really still don't have to send that much data (remember, this query is periodically called every 1 minute for EVERY user). commit ec43cd6bf1be52a0a101f85faf654610b27c6df6 Author: Joseph Marques <joseph> Date: Wed Nov 24 18:17:10 2010 -0500 BZ-657107: support querying alert count by criteria (and show in footer) tested alerts. from an empirical standpoint, i am seeing response time < 10 seconds (arbitrary performance SLA) in the alert area. when alerts are slow, it seems to be related entirely to the UI layer with CPU utilization at 100% attributed to Firefox browser and not the server response time. there is a more full-blown performance effort underway, and fully intend to identify and optimize performance from that perspective. Bulk closing of issues that were VERIFIED, had no target release and where the status changed more than a year ago. |