Opened 13 years ago
#208 new enhancement
Constitutions: curb sql usage growth
| Reported by: | adehnert | Owned by: | |
|---|---|---|---|
| Priority: | normal | Milestone: | Sometime |
| Component: | Reporting | Version: | |
| Keywords: | Cc: | ||
| Size: | medium |
Description
The GroupConstitution? object is versioned using reversion. This means that every night we download 400-odd constitutions, update the last updated date, and make a new reversion version. At the moment, these take up about 25MB. We should either talk to sql.mit.edu about getting a quota bump, or conclude that this isn't sustainable and:
- purge old versions (or ideally no-change version) regularly and/or
- not create a new version when the constitution hasn't changed
Note: See
TracTickets for help on using
tickets.
