← Back to team overview

openerp-community team mailing list archive

Re: odoo with a daily 50000 orders volume

 

Indeed, VM is not as good as bare metal for PSQL, but I am just giving an
example that even in VMs good results can be obtained when tuned with clean
code.



Vadim





*From:* Paul Catinean [mailto:paulcatinean@xxxxxxxxx]
*Sent:* 08 October 2014 15:17
*To:* Enapps :: Vadim Chobanu
*Cc:* Frédéric Clementi; Nhomar Hernández; lin.yu; OpenERP Community
*Subject:* Re: [Openerp-community] odoo with a daily 50000 orders volume



Vadim,



Regardin the VM I remember the performance workshop held two years ago at
Opendays said that using a VM is something to be avoided completely, if
possible of course, due to PostgreSQL not running at optimum
efficiency.Also using SSD, pg_tune and other improvements as such can make
a great impact



All of this is just more brute-force for a system that can be much less
'greedy' though



On Wed, Oct 8, 2014 at 12:58 PM, Enapps :: Vadim Chobanu <vadim@xxxxxxxxxxxx>
wrote:

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
glance.

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.

Cheers,





*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.




*camp**to**camp*

INNOVATIVE SOLUTIONS

BY OPEN SOURCE EXPERTS



*Frédéric Clementi*

Project Manager

Business Solutions



+41 21 619 10 41



www.camptocamp.com





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

http://www.jianshu.com/p/eda222886d7a



Your comments are welcome.


Hello.



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?



http://www.slideshare.net/openobject/performance2014-35689113






-- 

--------------------
Saludos Cordiales



*Nhomar Hernandez*

about.me/nhomar




_______________________________________________
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




_______________________________________________
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


References