Community mailing list archives

Re: Database management for large odoo deployment

OPENTIA S.L., Alberto Barrionuevo
- 03/23/2015 06:29:06
Hi John, Lionel,

     we have done this already for a huge logistic and e-commerce Odoo:

     The solution is always on demand for your own Odoo version, customization, use and developments.

Best regards,
Alberto Barrionuevo, Director
Odoo/OpenERP Silver Partners
T (+34) 918 38 38 58
F (+34) 944 34 00 77

Open Tech for Open Minds

<blockquote cite="" type="cite">
---------- Forwarded message ----------
From: Lionel Sausin <>
Date: 23 March 2015 at 10:07
Subject: Re: Database management for large odoo deployment
To: Community <>

You will certainly need database tuning and code optimization, depending 
on the type of transactions you record.
We have 12000 stock locations and 1M stock moves/year and keeping it 
smooth is not trivial, we need to make optimizations regularly and we 
need to be extra careful when developing custom modules.

Also, because Odoo does all the reporting on the operational database, 
all analysis views become mostly unworkable with too much data. You may 
have to arrange other means of reporting (envisage a distinct data 
warehouse if you can).

Odoo SA can offer optimization services for a fee.
By the way, are there other partners reading this who are able to sell 
optimization services too?

Le 20/03/2015 11:38, John Pia Jr a écrit :
> Does anybody have any experience for hips for managing large 
> databases. we will have around 3000 to 5000 transactions or records 
> created in the database each day. As time goes on it's clear that this 
> database will become massive. does anybody have experience with 
> something of this size and if so in your experience does odoo require 
> A large amount if any of management in order to ensure the performance 
> does not hinder once the database grows. I'm just looking for some 
> insight here thank you
> _______________________________________________
> Mailing-List:

Post to: