Bug 534674 (RHQ-1448) - Add schedule id index to raw tables
Summary: Add schedule id index to raw tables
Alias: RHQ-1448
Product: RHQ Project
Classification: Other
Component: Database (Show other bugs)
(Show other bugs)
Version: unspecified
Hardware: All All
medium vote
Target Milestone: ---
: ---
Assignee: Joseph Marques
QA Contact:
URL: http://jira.rhq-project.org/browse/RH...
Keywords: SubTask
Depends On:
Blocks: RHQ-1002
TreeView+ depends on / blocked
Reported: 2009-01-30 22:47 UTC by Charles Crouch
Modified: 2015-02-01 23:25 UTC (History)
1 user (show)

Fixed In Version: 1.3
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed:
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

Description Charles Crouch 2009-01-30 22:47:00 UTC

Comment 1 Charles Crouch 2009-02-06 21:03:22 UTC
r2946 update dbsetup
r2947 update dbupgrade

Comment 2 Heiko W. Rupp 2009-02-06 21:11:44 UTC
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.

Comment 3 Charles Crouch 2009-02-10 14:46:30 UTC
Initial one-off test: loading the metric tab for a 450member group (5charts)took a bit over 2mins

Comment 4 Charles Crouch 2009-02-23 23:32:31 UTC
Changes have been applied, not the final answer, but looks like an improvement.

Comment 5 John Mazzitelli 2009-08-10 17:27:45 UTC
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

Comment 6 Joseph Marques 2009-08-25 17:11:01 UTC
rev4989 - remove schedule_id index on raw tables; 
add time_stamp index on raw tables; 

Comment 7 Charles Crouch 2009-09-01 15:00:08 UTC
Assigning to Joseph who is working on migrating our perf branch fixes to /trunk

Comment 8 Joseph Marques 2009-09-03 07:53:45 UTC
rev5087 - remove schedule_id index on raw tables, which is redundant with the composite index already on those respective tables; 

Comment 9 Red Hat Bugzilla 2009-11-10 20:33:12 UTC
This bug was previously known as http://jira.rhq-project.org/browse/RHQ-1448

Note You need to log in before you can comment on or make changes to this bug.