Bug 1356560 - [scale] Getting user VMs from user portal is taking too long
Summary: [scale] Getting user VMs from user portal is taking too long
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: ovirt-engine
Classification: oVirt
Component: Database.Core
Version: 4.0.0
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: ovirt-4.1.0-alpha
: 4.1.0
Assignee: Oved Ourfali
QA Contact: eberman
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-07-14 11:37 UTC by Eli Mesika
Modified: 2017-04-27 09:37 UTC (History)
6 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2017-04-27 09:37:17 UTC
oVirt Team: Infra
Embargoed:
rule-engine: ovirt-4.1+
rule-engine: planning_ack+
mperina: devel_ack+
lsvaty: testing_ack+

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
oVirt gerrit 60722 0 master MERGED core: Getting user VMs from user portal... 2016-07-21 09:29:14 UTC

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
Note You need to log in before you can comment on or make changes to this bug.