Change in ovirt-engine[master]: core: Improve performance of GetStorageConnectionsByStorageT...
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(a)redhat.com <lzelkha(a)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(a)redhat.com>
Gerrit-Reviewer: Allon Mureinik <amureini(a)redhat.com>
Gerrit-Reviewer: Daniel Erez <derez(a)redhat.com>
Gerrit-Reviewer: Eldad Marciano <emarcian(a)redhat.com>
Gerrit-Reviewer: Eli Mesika <emesika(a)redhat.com>
Gerrit-Reviewer: Liran Zelkha <lzelkha(a)redhat.com>
Gerrit-Reviewer: Maor Lipchuk <mlipchuk(a)redhat.com>
Gerrit-Reviewer: Oved Ourfali <oourfali(a)redhat.com>
Gerrit-Reviewer: automation(a)ovirt.org
Gerrit-Reviewer: oVirt Jenkins CI Server