Community mailing list archives

Re: database cleanup

Andi Becker
- 12/02/2015 11:39:06
Well Martin

Depending in which country you are living data has to be kept for a certain time - in Thailand it is 5 years - and afterwards you should actually try to get rid of it as also here they call it privacy etc (even no one seems to check it as long as your neighbour does not tell them!) 

A growing database also results in speed and performance losses. Especially if you have lots of other stuff stored there to. i.e. from the website module and you want to get rid of old articles or stuff which is not at all relevant for seo anymore.

Removing transactions within a year can be dangerous, you are absolutely right! I would not advise it either. But anyway an easy way to cut of all data no more needed would be fine.

Otherwise you are ending u like a Facebook Backup which is 2-3 or even more GB to be downloaded, even you would need only the last months or only a certain part of it, what has been stored in the DB.

With kind regards,
Mit freundlichen Grüßen,
Con un cordial saludo,
с сердечным приветом,


CEO/General Manager LisAndi Co., Ltd.


LisAndi Co. Ltd., Phuket, Thailand (
15/21 M.2 Viset Road, Rawai, Muang, Phuket, Thailand 83130

Mobile: +66 (0)81 606 3378
VoIP:   +49 (0)711 50 88788 50
Fax:     +49 (0)711 50 88788 50
Skype:          lisandi
Facebook:     andibecker
Google Talk/Facetime/eMail:


This email may contain confidential and/or privileged information. If you are not the intended recipient (or have received this email by mistake), please notify the sender immediately and destroy this email. Any unauthorized copying, disclosure or distribution of the material in this email is strictly prohibited. Email transmission security and error-free status cannot be guaranteed as information could be intercepted, corrupted, destroyed, delayed, incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which may arise as a result of email transmission

On Wed, Dec 2, 2015 at 10:32 PM, Martin Trigaux <> wrote:
On 02/12/15 16:12, Andreas Becker wrote:
> This is a very good question - Keeping your database clean should be
> easy as it would be good to do this every year at least.

I don't really think that's a good idea. Removing some records such as 
accounting transactions or other moves is a risk to lose information, 
break flows or be stuck at migrations.
I wouldn't advise it if you don't know exactly what you are doing or 
have very good reason to do so (other than "keep my db tidy").

@Franco you ask something very specific (remove this but keep that) so 
this should probably be a manual operation.
But again I wouldn't advise it.

And, as said Pedro, make copy of your database.

Martin Trigaux
Odoo (Formerly OpenERP)

Post to: