Database size growing due to attachments!

Question

Hi all,

my odoo db is running very large, mostly due to a high amount of attachments in crm and project app. Is this dangerous regarding responsiveness and speed?

the filestore size is currently 40 GB. Because of Odoo.sh's  [1] backups and staging branches, the total size amounts to 200+ GB.

Here are my questions:
whats the best way to reduce the database size deletion? will archiving records help? can i reduce the number of backups from 3 to 2? (=~25% less data) once reached, how seamless is

Savan Changela · Answer

The best way to reduce your database size is you have to move attachment somewhere else like google drive, Microsoft onedrive, etc. There are two types of attachments in odoo 'file' or 'url' in your case currently attachments will be File type once to move your attachment to other place you can change type to Url and add attachment public url there and remove old data.

Gerelateerde posts	Antwoorden	Weergaven
database backup keep getting corrupted database filestore odoo16	2 mrt. 25	2332
ir_attachment_force_storage then files not found database filestore attachments	0 aug. 18	4664
ODOO9: which is better filestore or database store Opgelost database filestore odoo9	1 mrt. 16	6742
Where the files uploaded on openerp are stocked ? database filestore v7	1 mrt. 15	5099
How to convert from filestore to databasestore? v6.1 database filestore	2 mrt. 15	13741

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!