Bug 616746 - Perf: consider putting an index on resource(id,parent_id)
Summary: Perf: consider putting an index on resource(id,parent_id)
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: RHQ Project
Classification: Other
Component: Database
Version: 3.0.0
Hardware: All
OS: Linux
low
medium vote
Target Milestone: ---
: ---
Assignee: RHQ Project Maintainer
QA Contact: Mike Foley
URL:
Whiteboard:
Depends On:
Blocks: rhq-perf
TreeView+ depends on / blocked
 
Reported: 2010-07-21 10:28 UTC by Heiko W. Rupp
Modified: 2014-06-04 19:58 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2014-06-04 19:58:14 UTC

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

Description Heiko W. Rupp 2010-07-21 10:28:11 UTC 
For things like uninventory of resources, the resource id and parent id are queried.
Putting an index on this will considerably speed up things.

For the long term, some more clever (pre)computation is needed instead of the relatively expensive queries we have today.

See also

https://fedorahosted.org/pipermail/rhq-devel/2010-June/000204.html
https://fedorahosted.org/pipermail/rhq-devel/2010-July/000211.html
Comment 1 Jay Shaughnessy 2014-06-04 19:58:14 UTC 
We have individual indexes on ID and PARENT_ID.  I think this is sufficient.
Note You need to log in before you can comment on or make changes to this bug.