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(a)redhat.com <lzelkha(a)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(a)redhat.com>
Gerrit-Reviewer: Allon Mureinik <amureini(a)redhat.com>
Gerrit-Reviewer: Barak Azulay <bazulay(a)redhat.com>
Gerrit-Reviewer: Eli Mesika <elimesika(a)gmail.com>
Gerrit-Reviewer: Eli Mesika <emesika(a)redhat.com>
Gerrit-Reviewer: Liran Zelkha <lzelkha(a)redhat.com>
Gerrit-Reviewer: Oved Ourfali <oourfali(a)redhat.com>
Gerrit-Reviewer: automation(a)ovirt.org
Gerrit-Reviewer: oVirt Jenkins CI Server