openerp-community team mailing list archive
-
openerp-community team
-
Mailing list archive
-
Message #06927
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
References