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É about 11 years ago.
Updated over 9 years ago.
Category:
Web - Compliance & node report
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
- 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.
- Status changed from New to In progress
- 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
- 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
- Status changed from In progress to Pending technical review
- Assignee changed from Nicolas CHARLES to François ARMAND
- Status changed from Pending technical review to In progress
- Assignee changed from François ARMAND to Nicolas CHARLES
- 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
- Status changed from Pending technical review to Pending release
- % Done changed from 0 to 100
- Status changed from Pending release to Released
This bug has been fixed in Rudder 2.8.0~beta1, which was released today.
Check out:
- Tracker changed from Enhancement to User story
Also available in: Atom
PDF