Bug 1356560

Summary:	[scale] Getting user VMs from user portal is taking too long
Product:	[oVirt] ovirt-engine	Reporter:	Eli Mesika <emesika>
Component:	Database.Core	Assignee:	Oved Ourfali <oourfali>
Status:	CLOSED CURRENTRELEASE	QA Contact:	eberman
Severity:	medium	Docs Contact:
Priority:	medium
Version:	4.0.0	CC:	bugs, emesika, lsvaty, michal.skrivanek, mperina, oourfali
Target Milestone:	ovirt-4.1.0-alpha	Keywords:	Performance
Target Release:	4.1.0	Flags:	rule-engine: ovirt-4.1+ rule-engine: planning_ack+ mperina: devel_ack+ lsvaty: testing_ack+
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2017-04-27 09:37:17 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 Eli Mesika 2016-07-14 11:37:36 UTC

Description of problem:
Getting user VMs from user portal is taking too long 


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


How reproducible:


Steps to Reproduce:
1.Log in to the user portal with a valid user 
2.
3.

Actual results:
It takes more than 30 sec to get the user's VMs 


Expected results:
User Vms should be shown immediately 

Additional info:

GetVmsByUserId is getting the results by a join of 6the vms view with the permissions view 
It is more efficient in that case to get first from he permissions all the user VMs IDs to an array and query the vms view with that

Comment 1 Michal Skrivanek 2016-07-15 04:26:56 UTC

how large environment we're talking here?

Comment 8 Yaniv Kaul 2016-07-25 08:28:50 UTC

Gil - would be happy if the scale team will test this in 4.1.

Comment 9 Sandro Bonazzola 2016-12-12 13:57:10 UTC

The fix for this issue should be included in oVirt 4.1.0 beta 1 released on December 1st. If not included please move back to modified.

Comment 10 eberman 2017-04-12 08:06:57 UTC

verified on 4.1.1.2-0.1.el7
with 250 host (100 up) + ~1300 Vms

logged in with a user assigned with 1 Vm (defined as super User) 
Getting user VM from user portal was immediate