Project

General

Profile

Actions

User story #3946

closed

User story #3945: Store agent executions history in a 'lightweight' table, to speed up Rudder web interface

Add all mechanisms to store agent executions

Added by Vincent MEMBRÉ over 10 years ago. Updated about 9 years ago.

Status:
Released
Priority:
1
Category:
Web - Compliance & node report
Target version:
UX impact:
Suggestion strength:
User visibility:
Effort required:
Name check:
Fix check:
Regression:

Description

The process consists in:
  • looking for new reports
  • converting them to agent executions
  • storing them.
To do that we need :
  • A repository to store executions
  • A service that will look for new reports, based on the other repository
  • A repository to store the service status (last report saved, ...), this repository can be used for more usage
Actions #1

Updated by Vincent MEMBRÉ over 10 years ago

  • Pull Request set to https://github.com/Normation/rudder/pull/317

Added a pull request, it's working, but it needs some refactoring/cleaning before merging it.

Actions #2

Updated by Jonathan CLARKE over 10 years ago

  • Status changed from New to In progress
Actions #3

Updated by Nicolas CHARLES over 10 years ago

  • Status changed from In progress to Pending technical review
  • Assignee changed from Vincent MEMBRÉ to François ARMAND
  • Pull Request changed from https://github.com/Normation/rudder/pull/317 to https://github.com/Normation/rudder/pull/341
Actions #4

Updated by Nicolas CHARLES over 10 years ago

  • Status changed from Pending technical review to In progress
  • Assignee changed from François ARMAND to Nicolas CHARLES

oh, there's a weird bug with the status update date

Actions #5

Updated by Nicolas CHARLES over 10 years ago

  • Status changed from In progress to Pending technical review
  • Assignee changed from Nicolas CHARLES to François ARMAND

the PR as been updated

Actions #6

Updated by Nicolas CHARLES over 10 years ago

  • Status changed from Pending technical review to In progress
  • Assignee changed from François ARMAND to Nicolas CHARLES
Actions #7

Updated by Nicolas CHARLES over 10 years ago

  • Status changed from In progress to Pending technical review

I updated the PR to include a proper usage of the new table, by minimizing the number of queries to fetch reports
This is especially useful when using a distant postgresql database
On my test system, I get around 30% increase of perf with the previous commits, and this last one make the rule page display at the same speed (roughly) if there are 2 rules or 40 rules

Actions #8

Updated by Nicolas CHARLES over 10 years ago

  • Status changed from Pending technical review to Pending release
  • % Done changed from 0 to 100
Actions #9

Updated by Anonymous over 10 years ago

Actions #10

Updated by Vincent MEMBRÉ over 10 years ago

  • Status changed from Pending release to Released

This bug has been fixed in Rudder 2.8.0~beta1, which was released today.
Check out:

Actions #11

Updated by Benoît PECCATTE about 9 years ago

  • Tracker changed from Enhancement to User story
Actions

Also available in: Atom PDF