Community mailing list archives

Re: Database management for large odoo deployment

Dave Ellison
- 03/23/2015 06:21:34

Agree with the below. I would definitely split out the two to separate
servers, web and database server at an absolute minimum. I am no DBMS
guru, but I do have a monthly check on tables, like vacuum etc. Which
helps to optimise the database as well.

Kind regards

On Mon, 2015-03-23 at 09:07 +0000, Lionel Sausin wrote:
> 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:
> > Unsubscribe:
> >
> _______________________________________________
> Mailing-List:
> Post to:
> Unsubscribe: