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

Avatar

Re: Reducing the size of a database

by
florian.laporte
- 23/01/2024 15:53:11

Dear Victor,

How large are these databases? Database size usually does not become problematic as a result of too many sale orders or stock movements. You would need an insane amount.
If this is the case, and you’ve verified that the size is not caused by large blobs/filestore, the only thing you can do is mass-delete records based on some arbitrary parameter like their create_date or write_date. There are many records Odoo won’t let you delete, though. It will ask you to archive them instead, because they are still referenced elsewhere. Archiving will obviously do nothing for database size.

Sincerely,

Florian L


On Tue, 23 Jan 2024 at 15:22, Victor Champonnois <notifications@odoo-community.org> wrote:

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

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

Reference