Bug 534674 (RHQ-1448) - Add schedule id index to raw tables
Summary: Add schedule id index to raw tables
Keywords:
Status: CLOSED NEXTRELEASE
Alias: RHQ-1448
Product: RHQ Project
Classification: Other
Component: Database
Version: unspecified
Hardware: All
OS: All
high
medium
Target Milestone: ---
: ---
Assignee: Joseph Marques
QA Contact:
URL: http://jira.rhq-project.org/browse/RH...
Whiteboard:
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:
Clone Of:
Environment:
Last Closed:
Embargoed:

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.