← Back to team overview

openerp-community team mailing list archive

Re: 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


Follow ups

References