Change in ovirt-engine[ovirt-engine-4.0.6]: core: improving vms_with_tags view performance

Tal Nisan has submitted this change and it was merged. Change subject: core: improving vms_with_tags view performance ...................................................................... core: improving vms_with_tags view performance 1) Adding "DISTINCT" to the view to eliminate duplications 2) Changing the "WHERE" condition to include VMs once and include also VMs that have no disks Patch was tested on the customer DB reported in the BZ and showed significant performance Change-Id: Ib5a6637b7c890e445940c8d0a770c2bd7e11e72b Bug-Url: https://bugzilla.redhat.com/1398550 Signed-off-by: emesika <emesika(a)redhat.com&gt; Signed-off-by: Martin Perina <mperina(a)redhat.com&gt; --- M packaging/dbscripts/create_views.sql 1 file changed, 5 insertions(+), 6 deletions(-) Approvals: Martin Peřina: Verified Jenkins CI: Passed CI tests Oved Ourfali: Looks good to me, approved -- To view, visit https://gerrit.ovirt.org/67324 To unsubscribe, visit https://gerrit.ovirt.org/settings Gerrit-MessageType: merged Gerrit-Change-Id: Ib5a6637b7c890e445940c8d0a770c2bd7e11e72b Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: ovirt-engine-4.0.6 Gerrit-Owner: Martin Peřina <mperina(a)redhat.com&gt; Gerrit-Reviewer: Jenkins CI Gerrit-Reviewer: Martin Peřina <mperina(a)redhat.com&gt; Gerrit-Reviewer: Oved Ourfali <oourfali(a)redhat.com&gt; Gerrit-Reviewer: Piotr Kliczewski <piotr.kliczewski(a)gmail.com&gt; Gerrit-Reviewer: Tal Nisan <tnisan(a)redhat.com&gt; Gerrit-Reviewer: gerrit-hooks <automation(a)ovirt.org&gt;