1. Mailing Lists
  2. Contributors
  3. Re: Reducing the size of a database

Contributors mailing list archives

contributors@odoo-community.org

Browse archives

Re: Reducing the size of a database

Re: Reducing the size of a database

Avatar

Re: Reducing the size of a database

by
Therp, Tom Blauwendraat
- 23/01/2024 16:18:22 
I've seen this module:

https://apps.odoo.com/apps/modules/13.0/muk_autovacuum/

Obviously this can't be used on just any models, but for some models I 
guess such an approach can work.

Another idea I've proposed to a customer once, was to have a moment at 
end of year where you create an "archive copy instance" for that year, 
where people can login but not change anything. The code at that point 
is also frozen and copied with. It's a dirty approach, as you'll after N 
years be sitting with N archive instances, but there's a chance that at 
some point they'll start agreeing to delete the oldest instance (as at 
least here in NL, there's a year limit to which you are obliged to keep 
financial history). The upside to this approach is that you can 
aggressively start deleting records from live.

-Tom

Reference