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

Contributors mailing list archives

contributors@odoo-community.org

Browse archives

OCA/connector-telephony Mantainers/PSC

Workers on odoo.sh

Avatar

Reducing the size of a database

by
Victor
- 23/01/2024 15:16:52

Dear contributors,

Some of our customers have been using their database for more than 6 years. They want to reduce the size of the database, by archiving/aggregating old data (accounting entries, sales lines, stock movements, etc.). It would also be easier to do exports, pivot tables and so on.

I see different solutions :

1. Manually aggregate old data, with a specific method  by type of tables (account move lines, stock picking, sale order lines). For instance, aggregate old accounting entries with annual miscellaneous operations. Of course, we should keep a backup of the old data somewhere.

2. Mass delete all the old and unused records, such as canceled POs, articles created by mistake. I don't see a way to do this quickly.

Maybe an alternative solution would be a module that sets a "limit date" that acts as an automatic filter when doing exports, pivots, etc.

Do you know any tool or procedure that would help with this ?

Best regards,
-- 
Victor Champonnois - Coop IT Easy
Tel : +32 475 81 01 12

Follow-Ups