Change in ovirt-engine[master]: engine: Improving almost all retrieves of storage_domains ob...
Michael Kublin has submitted this change and it was merged.
Change subject: engine: Improving almost all retrieves of storage_domains object in the
system
......................................................................
engine: Improving almost all retrieves of storage_domains object in the system
The following patch should improve all queries that retrieving a storage_domains object
at the system except iso domain.
The problem was in fn_get_storage_domain_shared_status_by_domain_id, all calculation
should be
done only for iso storage domain.
The following query was also reported as problematic in bug #879930, so I added a bug
number to
commit message
Change-Id: I617a631c63cd38f058e6c0711dea3a43062874fd
Bug-Url: https://bugzilla.redhat.com/879930
Signed-off-by: Michael Kublin <mkublin(a)redhat.com>
---
M backend/manager/dbscripts/create_functions.sql
M backend/manager/dbscripts/create_views.sql
2 files changed, 59 insertions(+), 48 deletions(-)
Approvals:
Michael Kublin: Verified; Looks good to me, approved
--
To view, visit http://gerrit.ovirt.org/9511
To unsubscribe, visit http://gerrit.ovirt.org/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I617a631c63cd38f058e6c0711dea3a43062874fd
Gerrit-PatchSet: 3
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Michael Kublin <mkublin(a)redhat.com>
Gerrit-Reviewer: Allon Mureinik <amureini(a)redhat.com>
Gerrit-Reviewer: Asaf Shakarchi <asaf(a)redhat.com>
Gerrit-Reviewer: Eli Mesika <emesika(a)redhat.com>
Gerrit-Reviewer: Michael Kublin <mkublin(a)redhat.com>
Gerrit-Reviewer: Yair Zaslavsky <yzaslavs(a)redhat.com>