Oved Ourfali has submitted this change and it was merged. Change subject: userportal: optimize GetAllFromVms query ...................................................................... userportal: optimize GetAllFromVms query Rewrote the stored function to optimize the query inside GetAllFromVms Splitting out the boolean for simplicity Joining instead of using exists on a complicated view Removing distinct, as it's already inside the joined view Change-Id: I541c9172c3ba9bcf989f9660baf06ec2e1fd02d7 Bug-Url: https://bugzilla.redhat.com/1151477 Signed-off-by: Tim Speetjens <tim.speetjens@redhat.com> --- M packaging/dbscripts/vms_sp.sql 1 file changed, 11 insertions(+), 6 deletions(-) Approvals: Pablo Iranzo Gómez: Looks good to me, but someone else must approve Omer Frenkel: Looks good to me, approved Tim Speetjens: Verified Liran Zelkha: Looks good to me, but someone else must approve Tomáš Došek: Verified; Looks good to me, but someone else must approve -- To view, visit http://gerrit.ovirt.org/34006 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: merged Gerrit-Change-Id: I541c9172c3ba9bcf989f9660baf06ec2e1fd02d7 Gerrit-PatchSet: 2 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Tim Speetjens <tim.speetjens@gmail.com> Gerrit-Reviewer: Eli Mesika <emesika@redhat.com> Gerrit-Reviewer: Liran Zelkha <lzelkha@redhat.com> Gerrit-Reviewer: Omer Frenkel <ofrenkel@redhat.com> Gerrit-Reviewer: Oved Ourfali <oourfali@redhat.com> Gerrit-Reviewer: Pablo Iranzo Gómez <Pablo.Iranzo@redhat.com> Gerrit-Reviewer: Tim Speetjens <tim.speetjens@gmail.com> Gerrit-Reviewer: Tomáš Došek <tdosek@redhat.com> Gerrit-Reviewer: automation@ovirt.org Gerrit-Reviewer: oVirt Jenkins CI Server