Bug 534674 (RHQ-1448)
Summary: | Add schedule id index to raw tables | ||
---|---|---|---|
Product: | [Other] RHQ Project | Reporter: | Charles Crouch <ccrouch> |
Component: | Database | Assignee: | Joseph Marques <jmarques> |
Status: | CLOSED NEXTRELEASE | QA Contact: | |
Severity: | medium | Docs Contact: | |
Priority: | high | ||
Version: | unspecified | CC: | hbrock |
Target Milestone: | --- | Keywords: | SubTask |
Target Release: | --- | ||
Hardware: | All | ||
OS: | All | ||
URL: | http://jira.rhq-project.org/browse/RHQ-1448 | ||
Whiteboard: | |||
Fixed In Version: | 1.3 | Doc Type: | Bug Fix |
Doc Text: | Story Points: | --- | |
Clone Of: | Environment: | ||
Last Closed: | 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: | |||
Bug Blocks: | 534181 |
Description
Charles Crouch
2009-01-30 22:47:00 UTC
r2946 update dbsetup r2947 update dbupgrade Did you try to change the columns in the existing index to see if this makes a change? Do you have good timing values of the old state, as two indexes also mean double work for the database to update the 2nd index too. And it uses more tablespace. Initial one-off test: loading the metric tab for a 450member group (5charts)took a bit over 2mins Changes have been applied, not the final answer, but looks like an improvement. question as to why we created a new index when we already had a scheduleId/timestamp index. Oracle is saying add an index on timestamp. need to re-investigate this based on new performance numbers rev4989 - remove schedule_id index on raw tables; add time_stamp index on raw tables; Assigning to Joseph who is working on migrating our perf branch fixes to /trunk rev5087 - remove schedule_id index on raw tables, which is redundant with the composite index already on those respective tables; This bug was previously known as http://jira.rhq-project.org/browse/RHQ-1448 |