Arik Hadas has submitted this change and it was merged.
Change subject: core: numa node with cpus in one query
......................................................................
core: numa node with cpus in one query
In order to improve the inefficient retrieval of numa nodes
(per-host and per-VM), we unified two queries to single query.
Instead of getting the relevant nodes and then query their CPU
cores, we let the DB do that in a single query.
Change-Id: I212630eab537eb3bc3d4731ca66beed62353855d
Signed-off-by: Arik Hadas <ahadas(a)redhat.com>
---
M
backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/VdsNumaNodeDaoImpl.java
M
backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/VmNumaNodeDaoImpl.java
M packaging/dbscripts/create_views.sql
M packaging/dbscripts/numa_sp.sql
4 files changed, 29 insertions(+), 93 deletions(-)
Approvals:
Jenkins CI: Passed CI tests
Roy Golan: Looks good to me, approved
Arik Hadas: Verified
--
To view, visit
https://gerrit.ovirt.org/52869
To unsubscribe, visit
https://gerrit.ovirt.org/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I212630eab537eb3bc3d4731ca66beed62353855d
Gerrit-PatchSet: 17
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Arik Hadas <ahadas(a)redhat.com>
Gerrit-Reviewer: Arik Hadas <ahadas(a)redhat.com>
Gerrit-Reviewer: Eli Mesika <emesika(a)redhat.com>
Gerrit-Reviewer: Jenkins CI
Gerrit-Reviewer: Martin Peřina <mperina(a)redhat.com>
Gerrit-Reviewer: Michal Skrivanek <mskrivan(a)redhat.com>
Gerrit-Reviewer: Roman Mohr <rmohr(a)redhat.com>
Gerrit-Reviewer: Roy Golan <rgolan(a)redhat.com>
Gerrit-Reviewer: Shahar Havivi <shavivi(a)redhat.com>
Gerrit-Reviewer: gerrit-hooks <automation(a)ovirt.org>