Michael Kublin has submitted this change and it was merged. Change subject: engine: Improving GetAsyncTasksByStoragePoolId query ...................................................................... engine: Improving GetAsyncTasksByStoragePoolId query The following patch will simplify a query, we don't need to make any join, access to async_tasks table is enough Change-Id: I295291a2ac84e021b7354a3fd072ba5534af533d Signed-off-by: Michael Kublin <mkublin(a)redhat.com&gt; --- M backend/manager/dbscripts/async_tasks_sp.sql M backend/manager/modules/dal/src/test/java/org/ovirt/engine/core/dao/AsyncTaskDAOTest.java 2 files changed, 5 insertions(+), 6 deletions(-) Approvals: Michael Kublin: Verified; Looks good to me, approved -- To view, visit http://gerrit.ovirt.org/13615 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: merged Gerrit-Change-Id: I295291a2ac84e021b7354a3fd072ba5534af533d Gerrit-PatchSet: 3 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Michael Kublin <mkublin(a)redhat.com&gt; Gerrit-Reviewer: Barak Azulay <bazulay(a)redhat.com&gt; Gerrit-Reviewer: Eli Mesika <emesika(a)redhat.com&gt; Gerrit-Reviewer: Michael Kublin <mkublin(a)redhat.com&gt; Gerrit-Reviewer: Yair Zaslavsky <yzaslavs(a)redhat.com&gt;