Bug 1375293 - Relationships filter_by_resource_type scope
Summary: Relationships filter_by_resource_type scope
Keywords:
Status: ON_QA
Alias: None
Product: Red Hat CloudForms Management Engine
Classification: Red Hat
Component: Performance
Version: 5.6.0
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: GA
: 5.7.0
Assignee: dmetzger
QA Contact: Pradeep Kumar Surisetty
URL:
Whiteboard:
Depends On:
Blocks: 1376160
TreeView+ depends on / blocked
 
Reported: 2016-09-12 15:49 UTC by John Prause
Modified: 2021-04-04 12:49 UTC (History)
3 users (show)

Fixed In Version: 5.7.0.0
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
: 1376160 (view as bug list)
Environment:
Last Closed:
Category: ---
Cloudforms Team: ---
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description John Prause 2016-09-12 15:49:54 UTC
These are prep steps for #10160 - only save 1 record coming back from vm.parent_blue_folders
They allow the other PR to avoid many queries (from 8 -> 3)
before
ms 	objects 	queries 	query (ms) 	rows 	comments
89.7 	23,359 	8 	19.0 	14 	no name-1
5.0 			0.3 	2 	.SELECT "relationships".*
0.3 			0.2 	1 	.SELECT "relationships".*
0.3 			0.2 	1 	.SELECT "relationships".*
0.5 			0.4 	1 	.SELECT "ems_folders".*
0.4 			0.3 	1 	.SELECT "relationships".*
0.3 			0.2 	1 	.SELECT "relationships".*
0.5 			0.4 	4 	.SELECT "relationships".*
11.7 			0.3 	3 	.SELECT "ems_folders".*
after
ms 	objects 	queries 	query (ms) 	rows 	comments
90.0 	23,557 	8 	19.6 	13 	no name-1
4.9 			0.3 	2 	.SELECT "relationships".*
0.4 			0.3 	1 	.SELECT "relationships".*
0.3 			0.2 	1 	.SELECT "relationships".*
0.5 			0.4 	1 	.SELECT "ems_folders".*
0.3 			0.2 	1 	.SELECT "relationships".*
0.3 			0.2 	1 	.SELECT "relationships".*
0.6 			0.5 	3 	.SELECT "relationships".*
12.3 			0.3 	3 	.SELECT "ems_folders".*

Comment 2 John Prause 2016-09-12 15:50:49 UTC
https://github.com/ManageIQ/manageiq/pull/10288


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