House cleaning is done during analysis of projects in 2 main streams :
Removing useless data
When you do a new analysis of your project, some data that were present in Sonar will not be accessible anymore. For example the source code of the previous analysis, measures at file level... Those data will automatically be removed at the end of a new analysis.
Removing un-necessary analysis
This is very useful to analyze frequently a project in Sonar to see progress on quality. It is also very useful to be able to see the trends over weeks / months / years. But when you are back in time, you do not really need the same level of details as you would for one week ago. Therefore, since Sonar 2.5, a new "Database Cleaner" has been added to Sonar. It aims to delete some rows in database to save some space and to improve overall performances. Here is its default configuration :
- it deletes all data older than 5 years
- it keeps a single monthly analysis by project over 1 year
- it keeps a single weekly analysis by project over 1 month
- analysis with an event are kept
These settings can be changed in the page Configuration > Settings > Database Cleaner.
Labels
