Project

General

Profile

Actions
Copy link

Architecture #18093

closed

Architecture #18092: Improve compliance performance and reliability

Simplify queries to detects runs in database, as all runs are complete

Added by Nicolas CHARLES over 3 years ago. Updated over 2 years ago.

Status:
Released
Priority:
N/A
Assignee:
Elaad FURREEDAN
Category:
Performance and scalability
Target version:
7.0.0~beta1
Pull Request:
https://github.com/Normation/rudder/p...
Effort required:
Name check:
To do
Fix check:
To do
Regression:

Description

rudder-relayd is the only component writing reports in database
so a full run is written in the database in a transaction, so there are partial run anymore
we should simplify queries that detect runs

This change improve, on the load platform, perfs from Store Agent Run Times batch by going from 195 batchs taking more than 5 seconds in 14 hours to 40 in 6 hours.

Please note that it does not change method updateExecutions in WoReportsExecutionRepositoryImpl which could simply become saveExecutions

Subtasks 1 (0 open — 1 closed)

Architecture #18910: Simpifying agent run request breaks testReleasedNicolas CHARLESActions
Actions
Copy link

Also available in: Atom PDF