Project

General

Profile

Actions

Architecture #9582

open

Query to get config of last run can be pretty expensive when there are a lot of new nodes runs

Added by Nicolas CHARLES about 8 years ago. Updated 15 days ago.

Status:
New
Priority:
N/A
Assignee:
-
Category:
Performance and scalability
Target version:
Effort required:
Name check:
Fix check:
Regression:

Description

The query to get last nodes runs configuration is ok, but when we have a significant number of nodes to filter on, it gets pretty slow (from 50ms to 2s with 900 nodes)
There is a threashold where it is cheaper to simply take all nodes, and filter in scala (as taking all nodes is more about 1s on my test system)

(note: this is also true in 3.1 implementation to get expected reports)

This needs more testing, obviously, but it could improve dashboard loading at web interface start, or when all nodes are answering at the same time

Actions

Also available in: Atom PDF