Community mailing list archives
Re: Database management for large odoo deploymentby
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,
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.
-- 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">
From: Lionel Sausin <email@example.com>
Date: 23 March 2015 at 10:07
Subject: Re: Database management for large odoo deployment
To: Community <firstname.lastname@example.org>
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