Contributors mailing list archives
contributors@odoo-community.org
Browse archives
Reducing the size of a database
byDear 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 ?
--
Victor Champonnois - Coop IT Easy
Tel : +32 475 81 01 12
Follow-Ups
-
Re: Reducing the size of a database
by "Graeme Gellatly" <graeme@moahub.nz> - 23/01/2024 21:24:04 - 0 -
-
Re: Reducing the size of a database
by "Ronald Portier" <rportier@therp.nl> - 23/01/2024 16:18:36 - 0 -
-
