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@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@redhat.com> Gerrit-Reviewer: Arik Hadas <ahadas@redhat.com> Gerrit-Reviewer: Eli Mesika <emesika@redhat.com> Gerrit-Reviewer: Jenkins CI Gerrit-Reviewer: Martin Peřina <mperina@redhat.com> Gerrit-Reviewer: Michal Skrivanek <mskrivan@redhat.com> Gerrit-Reviewer: Roman Mohr <rmohr@redhat.com> Gerrit-Reviewer: Roy Golan <rgolan@redhat.com> Gerrit-Reviewer: Shahar Havivi <shavivi@redhat.com> Gerrit-Reviewer: gerrit-hooks <automation@ovirt.org>