← Back to team overview

openerp-community team mailing list archive

Re: odoo with a daily 50000 orders volume

 

It seems that the attachments didn't pass the mail list filter. We will publish them during the following hours.

Sorry,
//Alberto.

On 08/10/14 20:56, Alberto Barrionuevo wrote:
Hi Fréderic, Nhomar,

On 08/10/14 09:05, Frédéric Clementi wrote:
Even with these tunings Odoo has no chance to handle such a volume of
data. We are already struggling at 3000 SO/day.ç

    Doing changes in the OpenERP v6.0 code to optimize and remove
serious performance problems that it has, and using a middleware in
front of OpenERP (v60), we have been able to manage +55.000 orders each
12 hours with this server architecture [attached systems hardware diagram].

    Since our architecture is not "as big", we are sure that we can
multiply that number using more application servers, since, once
optimized. With improvements we get the initial software limit moved
from OpenERP to PostgreSQL, that is much more powerful in terms of
scalability than the standard OpenERP.

    The attached video shows the parallel creation of 32 SO in 25
seconds using the hardware architecture finally used in productive. It
means 0,78 seconds per SO.

    Indeed, the sales orders being created in this demo are heavier than
the standard ones, since they include some custom business processes to
be executed in OpenERP before the SO is confirmed in the sales flow.
Orders originally come mainly from a web trading platform from the final
customer, but also from other sources, all them passing through our
middleware for OpenERP done with Django. In the video we are simulating
the source with our own launching script used in QA tests.

    Disclaimer: This kind of solutions are on demand for each actual
case. They cannot be generalized. Some of the used optimization
techniques may be more generally applied. Additionally, Odoo v7.0 and
8.0 would need less work to escalate than the v6.0 that we "suffered".

    If anybody is really interested, with some days work in advance to
install again the whole solution, we can prepare and show a working
demo. But it would use our demo servers that are less powerful than the
attached productive architecture.

Best regards,


_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to     : openerp-community@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp



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

           OPENTIA
Ingeniería Informática en Abierto
        www.opentia.com


Follow ups

References