Community mailing list archives

community@mail.odoo.com

Re: Database management for large odoo deployment

by
NUMERIGRAPHE, Lionel Sausin
- 03/23/2015 05:03:36
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: https://www.odoo.com/groups/community-59
> Post to: mailto:community@mail.odoo.com
> Unsubscribe: https://www.odoo.com/groups?unsubscribe
>