Community mailing list archives

community@mail.odoo.com

Re: Database management for large odoo deployment

by
YannickB
- 03/23/2015 07:01:38
I think we shall have in the technical documentation a checklist with all the important things to do to optimise the database. Some tips are often given in this mailing list, but there is no place where all the informations are summarized.

Of course the postgres documentation itself is very good, but I still think we shall have another documentation which give the tips specific for the Odoo case.

My two cents,

Le 23/03/2015 11:36, Alberto Barrionuevo a écrit :
<blockquote cite="mid:550FEAF2.1080504@opentia.es" type="cite">

Hi John, Lionel,

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

http://www.opentia.es/en/services-and-solutions/odoo-high-performance

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

Best regards,

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

      OPENTIA
Open Tech for Open Minds
   www.opentia.com


<blockquote cite="mid:CAH=PDDkOa9ZvjZXLajRVan0FP7vWiSu9Dnd5NYsPq7WZZz8mnA@mail.gmail.com" type="cite">
---------- Forwarded message ----------
From: Lionel Sausin <ls@numerigraphe.com>
Date: 23 March 2015 at 10:07
Subject: Re: Database management for large odoo deployment
To: Community <community@mail.odoo.com>


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

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe