Content
View differences
Updated by Oliver Günther almost 11 years ago
**As an** OpenProject.com Organization Owner
**I want to** see how much storage I used in total and per project
**so that** I can base decisions on that information (e.g. deleting a project, buying a higher subscription).
**Acceptance criteria**
- A column in project overview shows the sum of storage used for attachments (local and S3) and repository (SVN and GIT) per project
- The total used storage of all project shown in an attribute group in the admin projects table.
- A project admin can see the used storage for his project, shown as an attribute under Information tab.
- The project table loads in less than 0.5 seconds also for more than 5.000 projects (e.g. by pagination, asynchronous loading)
- Projects in the project table can be sorted numerically by used storage total.
**Technical Solution Concept**
From analysis in \#18799
- [Use OS mechanisms to collect the data](https://community.openproject.org/#142-OS-mechanisms) and trigger the update “Event based but dumb” so
- a delayed job is run for every access to the repository. This has to be made intelligent enough to reduce load to a minimum by avoiding unnecessary job executions. **There is a risk of high load here**
- The job is only run every N minutes (configurable in the global settings) when the repository is accessed through the frontend
- Using the sys API, a commit hook MAY optionally be configured to update the required storage upon commit access
- Attachment’s file size information already exists
**Out of Scope**
- Styling the project table
**Visuals**
- http://clients.zzmedia.net/openproject/administration/projects/
**I want to** see how much storage I used in total and per project
**so that** I can base decisions on that information (e.g. deleting a project, buying a higher subscription).
**Acceptance criteria**
- A column in project overview shows the sum of storage used for attachments (local and S3) and repository (SVN and GIT) per project
- The total used storage of all project shown in an attribute group in the admin projects table.
- A project admin can see the used storage for his project, shown as an attribute under Information tab.
- The project table loads in less than 0.5 seconds also for more than 5.000 projects (e.g. by pagination, asynchronous loading)
- Projects in the project table can be sorted numerically by used storage total.
**Technical Solution Concept**
From analysis in \#18799
- [Use OS mechanisms to collect the data](https://community.openproject.org/#142-OS-mechanisms) and trigger the update “Event based but dumb” so
- The job is only run every N minutes (configurable in the global settings) when the repository is accessed through the frontend
- Using the sys API, a commit hook MAY optionally be configured to update the required storage upon commit access
- Attachment’s file size information already exists
**Out of Scope**
- Styling the project table
**Visuals**
- http://clients.zzmedia.net/openproject/administration/projects/