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@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@redhat.com> Gerrit-Reviewer: Allon Mureinik <amureini@redhat.com> Gerrit-Reviewer: Asaf Shakarchi <asaf@redhat.com> Gerrit-Reviewer: Eli Mesika <emesika@redhat.com> Gerrit-Reviewer: Michael Kublin <mkublin@redhat.com> Gerrit-Reviewer: Yair Zaslavsky <yzaslavs@redhat.com>