Eli Mesika has submitted this change and it was merged. Change subject: core: Improve performance of GetStorageConnectionsByStorageTypeAndStatus ...................................................................... core: Improve performance of GetStorageConnectionsByStorageTypeAndStatus This Stored Procedure is slow because of distinct and UNION operators. The refactored implementation uses sub-selects to improve performance. This reduced execution time in the performance lab from 3s to <1s Change-Id: I8048b87fa321086469c892c3650f7c5548cc13d8 Bug-Url: https://bugzilla.redhat.com/1186763 Signed-off-by: lzelkha@redhat.com <lzelkha@redhat.com> --- M packaging/dbscripts/storages_san_sp.sql 1 file changed, 9 insertions(+), 13 deletions(-) Approvals: Allon Mureinik: Looks good to me, but someone else must approve Maor Lipchuk: Looks good to me, approved Liran Zelkha: Verified Eldad Marciano: Looks good to me, but someone else must approve -- To view, visit http://gerrit.ovirt.org/37528 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: merged Gerrit-Change-Id: I8048b87fa321086469c892c3650f7c5548cc13d8 Gerrit-PatchSet: 4 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Liran Zelkha <lzelkha@redhat.com> Gerrit-Reviewer: Allon Mureinik <amureini@redhat.com> Gerrit-Reviewer: Daniel Erez <derez@redhat.com> Gerrit-Reviewer: Eldad Marciano <emarcian@redhat.com> Gerrit-Reviewer: Eli Mesika <emesika@redhat.com> Gerrit-Reviewer: Liran Zelkha <lzelkha@redhat.com> Gerrit-Reviewer: Maor Lipchuk <mlipchuk@redhat.com> Gerrit-Reviewer: Oved Ourfali <oourfali@redhat.com> Gerrit-Reviewer: automation@ovirt.org Gerrit-Reviewer: oVirt Jenkins CI Server