← Back to team overview

openerp-community team mailing list archive

Re: odoo with a daily 50000 orders volume


As lin yu tests show, the bottleneck is the confirmation of sale/creation
of picking and such bottlenecks are everwhere, but not obvious at the first

We managed to finetune the process (get rid of workflow for starters), so
now confirming a sales order with 10  lines takes less than a second. This
is on a simple VM  (8Gb of Ram, 4 cores) and a 10Gb database peaking at 100
orders per hour.

Anything that takes more than 1 second to confirm an order with 10 lines is
simply not acceptable in production environments where at 4pm customers are
screaming wanting their orders to go out for next day delivery.


*Vadim Chobanu*

Managing Partner

[image: enapps logo email]

T: +44 020 8090 9222 ext 1005

M: +44 079 3923 0959

E: vadim@xxxxxxxxxxxx

W: www.enapps.co.uk

Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.

Address: 88 Wood Street; 10th floor; London EC2V 7RS

Registered in England No: 07746264

Reg. VAT No. GB 124 1001 86

*From:* Openerp-community [mailto:openerp-community-bounces+vadim=
enapps.co.uk@xxxxxxxxxxxxxxxxxxx] *On Behalf Of *Frédéric Clementi
*Sent:* 08 October 2014 08:05
*To:* Nhomar Hernández
*Cc:* OE Community openerp-community@xxxxxxxxxxxxxxxxxxx
*Subject:* Re: [Openerp-community] odoo with a daily 50000 orders volume

Even with these tunings Odoo has no chance to handle such a volume of data.
We are already struggling at 3000 SO/day.




*Frédéric Clementi*

Project Manager

Business Solutions

+41 21 619 10 41


2014-09-29 13:54 GMT+02:00 Nhomar Hernández <nhomar@xxxxxxxxx>:

2014-09-29 4:26 GMT-04:30 lin.yu <lin.yu@xxxxxxxxxxxxxx>:

You can find more test results and details here


Your comments are welcome.


I couldn't find some basic things mentioned in your post:

1.- are your running with what # of Workers?

2.- # of Cores?

3.- Load balancing?

4.- # Number of instances runing?

5.- Is it postgres optimized?

I have one customer like this, and my tests given different results (not
perfect but better than yours).

did you follow this advices?



Saludos Cordiales

*Nhomar Hernandez*


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

PNG image

Follow ups