Oved Ourfali has submitted this change and it was merged. Change subject: core: storage_domains_with_hosts_view generate slow query ...................................................................... core: storage_domains_with_hosts_view generate slow query When using the Host tab on the StorageDomain, a very slow query is generated. The following is a comparison of before/after from a scale environment: SELECT count(*) FROM vds WHERE ( vds_id IN (select vds_id from storage_domains_with_hosts_view WHERE storage_domains_with_hosts_view.storage_name LIKE 'storage_real')); count ------- 39 (1 row) Time: 7347.615 ms SELECT count(*) FROM vds WHERE ( storage_pool_id IN (select storage_pool_id from storage_domains WHERE storage_domains.storage_name LIKE 'storage_real')); count ------- 39 (1 row) Time: 528.767 ms Change-Id: Iab5887ea432de78776340da87ee873733bec7d15 Bug-Url: https://bugzilla.redhat.com/1097160 Signed-off-by: lzelkha@redhat.com <lzelkha@redhat.com> --- M backend/manager/modules/searchbackend/src/main/java/org/ovirt/engine/core/searchbackend/SyntaxChecker.java 1 file changed, 16 insertions(+), 0 deletions(-) Approvals: Eli Mesika: Looks good to me, approved Liran Zelkha: Verified -- To view, visit http://gerrit.ovirt.org/27634 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: merged Gerrit-Change-Id: Iab5887ea432de78776340da87ee873733bec7d15 Gerrit-PatchSet: 2 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Liran Zelkha <lzelkha@redhat.com> Gerrit-Reviewer: Allon Mureinik <amureini@redhat.com> Gerrit-Reviewer: Barak Azulay <bazulay@redhat.com> Gerrit-Reviewer: Eli Mesika <elimesika@gmail.com> Gerrit-Reviewer: Eli Mesika <emesika@redhat.com> Gerrit-Reviewer: Liran Zelkha <lzelkha@redhat.com> Gerrit-Reviewer: Oved Ourfali <oourfali@redhat.com> Gerrit-Reviewer: automation@ovirt.org Gerrit-Reviewer: oVirt Jenkins CI Server