Project

General

Profile

Actions

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
Category:
Performance and scalability
Target version:
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 open1 closed)

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

Updated by Nicolas CHARLES over 3 years ago

  • Status changed from New to In progress
  • Assignee set to Nicolas CHARLES
Actions #2

Updated by Nicolas CHARLES over 3 years ago

  • Description updated (diff)
Actions #3

Updated by Nicolas CHARLES over 3 years ago

  • Status changed from In progress to Pending technical review
  • Assignee changed from Nicolas CHARLES to Elaad FURREEDAN
  • Pull Request set to https://github.com/Normation/rudder/pull/3162
Actions #4

Updated by Nicolas CHARLES over 3 years ago

  • Status changed from Pending technical review to Pending release
Actions #5

Updated by Vincent MEMBRÉ over 3 years ago

  • Target version changed from 6.2.0~beta1 to 7.0.0~beta1
Actions #6

Updated by Vincent MEMBRÉ over 2 years ago

  • Status changed from Pending release to Released

This bug has been fixed in Rudder 7.0.0~beta1 which was released today.

Actions

Also available in: Atom PDF