Bug 616746

Summary: Perf: consider putting an index on resource(id,parent_id)
Product: [Other] RHQ Project Reporter: Heiko W. Rupp <hrupp>
Component: DatabaseAssignee: RHQ Project Maintainer <rhq-maint>
Status: CLOSED CURRENTRELEASE QA Contact: Mike Foley <mfoley>
Severity: medium Docs Contact:
Priority: low    
Version: 3.0.0CC: jshaughn
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-06-04 19:58:14 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---
Bug Depends On:    
Bug Blocks: 620933    

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.