Bug 1306324

Summary:	[scale] - GetStorageConnectionsByStorageTypeAndStatus generate slow query
Product:	[oVirt] ovirt-engine	Reporter:	Eldad Marciano <emarcian>
Component:	Database.Core	Assignee:	Eli Mesika <emesika>
Status:	CLOSED DUPLICATE	QA Contact:	Pavel Stehlik <pstehlik>
Severity:	medium	Docs Contact:
Priority:	unspecified
Version:	3.6.2	CC:	bugs
Target Milestone:	---	Flags:	rule-engine: planning_ack? rule-engine: devel_ack? rule-engine: testing_ack?
Target Release:	---
Hardware:	x86_64
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2016-02-10 15:21:20 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	Infra	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Eldad Marciano 2016-02-10 15:07:13 UTC

Description of problem:
SP GetStorageConnectionsByStorageTypeAndStatus response time grow when running 
many SD's

--10 rows \ SD's exe time = ~3.2sec

--1 row \ SD exe time = ~1.2sec

Version-Release number of selected component (if applicable):
rhevm 3.6.2

How reproducible:
100%

Steps to Reproduce:
1. 10K vms 12 SD's

Actual results:
execution time ~3 sec and above.

Expected results:
less than 1 sec.

Additional info:

Comment 1 Eldad Marciano 2016-02-10 15:21:20 UTC


*** This bug has been marked as a duplicate of bug 1306325 ***