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:paulcatin...@gmail.com] *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 <va...@enapps.co.uk> 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: va...@enapps.co.uk 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...@lists.launchpad.net] *On Behalf Of *Frédéric Clementi *Sent:* 08 October 2014 08:05 *To:* Nhomar Hernández *Cc:* OE Community openerp-community@lists.launchpad.net *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 <nho...@gmail.com>: 2014-09-29 4:26 GMT-04:30 lin.yu <lin...@elico-corp.com>: 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~openerp-community More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~openerp-community Post to : openerp-community@lists.launchpad.net Unsubscribe : https://launchpad.net/~openerp-community More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~openerp-community Post to : openerp-community@lists.launchpad.net Unsubscribe : https://launchpad.net/~openerp-community More help : https://help.launchpad.net/ListHelp
