Re: [Openerp-community] odoo with a daily 50000 orders volume

classic Classic list List threaded Threaded
12 messages Options
Reply | Threaded
Open this post in threaded view
|

Re: [Openerp-community] odoo with a daily 50000 orders volume

LIN Yu

Hi Community,


Following this email, I have prepared a test database with odoo trunk branch on a cloud server in Hong Kong  and did some test.

And I found out  that

* Create Delivery Order from sale order is extreamly slow.

* Checking Product stock with “stock.quant” objects is fast.


One of the test result is like this:

('create sale order', [372747], '2014-09-27 23:19:38.437345', '2014-09-27 23:19:38.721982', '0:00:00.284637')
('confirm sale order', 372747, '2014-09-27 23:19:38.722179', '2014-09-27 23:19:38.809885', '0:00:00.087706')
('create delivery order, picking_ids: ', [439882], '2014-09-27 23:19:38.810032', '2014-09-27 23:19:51.276784', '0:00:12.466752')
('confirm delivery order', [439882], '2014-09-27 23:19:51.316703', '2014-09-27 23:19:51.331486', '0:00:00.014783')
('assign delivery order', [439882], '2014-09-27 23:19:51.331564', '2014-09-27 23:19:51.520959', '0:00:00.189395')
('create sale invoice', [131590], '2014-09-27 23:19:51.521011', '2014-09-27 23:19:52.343078', '0:00:00.822067')
('open sale invoice', 131590, '2014-09-27 23:19:52.349533', '2014-09-27 23:19:54.428478', '0:00:02.078945')


You can find more test results and details here 

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

Your comments are welcome.

BR,
LIN Yu
Project Manager
--
Elico Corporation, Shenzhen branch
Odoo Gold Partner
China Phone: + 86 186 1691 1351
HK Phone: +852 6243 6892
Skype: llccluf
http://www.elico-corp.com

Elico Corp is best Partner Odoo 2014 for Asia-Pacific
Remember: with version 8, OpenERP becomes Odoo!
Elico
        Corp 

 Original Message 
Sender: lin.yu<[hidden email]>
Recipient: OE Community [hidden email]<[hidden email]>
Date: Monday, Aug 25, 2014 09:21
Subject: odoo with a daily 50000 orders volume

Hello Community,


We have a potential lead which has a volume of daily 20000 sale orders and 50000 sale order lines from Magento, which will probably result in a daily 100000 or 200000 stock moves, 3000000 stock moves per month.

I would like to ask that has anyone experience on Odoo/OpenERP with that daily volume? How about the performance after one month?


I would like also to ask if you have any module on 

* archive stock move , sales order, and other objects

* sales forecasting


BR,


_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to     : [hidden email]
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp
Reply | Threaded
Open this post in threaded view
|

Re: [Openerp-community] odoo with a daily 50000 orders volume

Nhomar Hernández

2014-09-29 4:26 GMT-04:30 lin.yu <[hidden email]>:


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?




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

_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to     : [hidden email]
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp
Reply | Threaded
Open this post in threaded view
|

Re: [Openerp-community] odoo with a daily 50000 orders volume

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


camptocamp
INNOVATIVE SOLUTIONS
BY OPEN SOURCE EXPERTS

Frédéric Clementi
Project Manager 
Business Solutions

+41 21 619 10 41



2014-09-29 13:54 GMT+02:00 Nhomar Hernández <[hidden email]>:

2014-09-29 4:26 GMT-04:30 lin.yu <[hidden email]>:


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?




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

_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to     : [hidden email]
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp



_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to     : [hidden email]
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp
Reply | Threaded
Open this post in threaded view
|

Re: [Openerp-community] odoo with a daily 50000 orders volume

Nhomar Hernández

2014-10-08 2:35 GMT-04:30 Frédéric Clementi <[hidden email]>:
Even with these tunings Odoo has no chance to handle such a volume of data. We are already struggling at 3000 SO/day.

What is the size of your hardware?

I had this problem present with v6.1 but v7.0 with a correct deployment can manage such quantity of data (not easy) but it can.

And what is the architecture of the apps:

Do you have synchronization with external tools with xmlrpc?
Bandwidth of the server?

I think such kind of volume of data needs more than a simple configuration of hardware, and teh last customer I had with such size of data had a Huuuuuge hardware behind (in v6 even) it is can manage everything smothly with some important tunning on some models, like account.move, CoA computation, stock.picking management and so on....

It means "by default" it is difficult, but with the correct tunning you can if you share with us some better sizing you deployed it can be more clear in what context Odoo is not working everybody will be thankful for that, only "Number of orders " doesn't say too much by itself dude.

Regards.
--
--------------------
Saludos Cordiales
 
 

_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to     : [hidden email]
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp
Reply | Threaded
Open this post in threaded view
|

Re: [Openerp-community] odoo with a daily 50000 orders volume

Enapps :: Vadim Chobanu
In reply to this post by Frédéric Clementi

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

enapps logo email

 

T: +44 020 8090 9222 ext 1005

M: +44 079 3923 0959

E: [hidden email]

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:[hidden email]=[hidden email]] On Behalf Of Frédéric Clementi
Sent: 08 October 2014 08:05
To: Nhomar Hernández
Cc: OE Community [hidden email]
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.

 


camptocamp
INNOVATIVE SOLUTIONS
BY OPEN SOURCE EXPERTS
 
Frédéric Clementi
Project Manager 
Business Solutions
 
+41 21 619 10 41
 
 

 

2014-09-29 13:54 GMT+02:00 Nhomar Hernández <[hidden email]>:

 

2014-09-29 4:26 GMT-04:30 lin.yu <[hidden email]>:

 

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?

 

 


 

--

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

 

Nhomar Hernandez

 


_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to     : [hidden email]
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp

 


_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to     : [hidden email]
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp
Reply | Threaded
Open this post in threaded view
|

Re: [Openerp-community] odoo with a daily 50000 orders volume

Marc Cassuto (SFL)
Hi Vadim,

it is not the first time, someone talk about getting rid of the workflows.
We are a lot to struggle with Odoo performance when running with high volume of data.

Should the community (or OCA) open a specific repository to share this experience,
the 'high speed' modules, discuss the solutions.

What do you all think about that ?

Regards,
Marc
==
Marc Cassuto, Ing. MBA Itil

SAVOIR-FAIRE LINUX
Consultant solutions ERP
T: 514-276-5468 #180


From: "Enapps :: Vadim Chobanu" <[hidden email]>
To: "Frédéric Clementi" <[hidden email]>, "Nhomar Hernández" <[hidden email]>, "lin.yu" <[hidden email]>
Cc: [hidden email]
Sent: Wednesday, October 8, 2014 6:58:05 AM
Subject: Re: [Openerp-community] 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 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

enapps logo email

 

T: +44 020 8090 9222 ext 1005

M: +44 079 3923 0959

E: [hidden email]

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:[hidden email]=[hidden email]] On Behalf Of Frédéric Clementi
Sent: 08 October 2014 08:05
To: Nhomar Hernández
Cc: OE Community [hidden email]
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.

 


camptocamp
INNOVATIVE SOLUTIONS
BY OPEN SOURCE EXPERTS
 
Frédéric Clementi
Project Manager 
Business Solutions
 
+41 21 619 10 41
 
 

 

2014-09-29 13:54 GMT+02:00 Nhomar Hernández <[hidden email]>:

 

2014-09-29 4:26 GMT-04:30 lin.yu <[hidden email]>:

 

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?

 

 


 

--

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

 

Nhomar Hernandez

 


_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to     : [hidden email]
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp

 


_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to     : [hidden email]
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp


_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to     : [hidden email]
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp
Reply | Threaded
Open this post in threaded view
|

Re: [Openerp-community] odoo with a daily 50000 orders volume

Paul Catinean
In reply to this post by Enapps :: Vadim Chobanu
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 <[hidden email]> 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

enapps logo email

 

T: <a href="tel:%2B44%20020%208090%209222%20ext%201005" value="+442080909222" target="_blank">+44 020 8090 9222 ext 1005

M: <a href="tel:%2B44%20079%203923%200959" value="+447939230959" target="_blank">+44 079 3923 0959

E: [hidden email]

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:[hidden email]=[hidden email]] On Behalf Of Frédéric Clementi
Sent: 08 October 2014 08:05
To: Nhomar Hernández
Cc: OE Community [hidden email]
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.

 


camptocamp
INNOVATIVE SOLUTIONS
BY OPEN SOURCE EXPERTS
 
Frédéric Clementi
Project Manager 
Business Solutions
 
<a href="tel:%2B41%2021%20619%C2%A010%2041" value="+41216191041" target="_blank">+41 21 619 10 41
 
 

 

2014-09-29 13:54 GMT+02:00 Nhomar Hernández <[hidden email]>:

 

2014-09-29 4:26 GMT-04:30 lin.yu <[hidden email]>:

 

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?

 

 


 

--

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

 

Nhomar Hernandez

 


_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to     : [hidden email]
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp

 


_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to     : [hidden email]
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp



_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to     : [hidden email]
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp
Reply | Threaded
Open this post in threaded view
|

Re: [Openerp-community] odoo with a daily 50000 orders volume

Enapps :: Vadim Chobanu

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:[hidden email]]
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 <[hidden email]> 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

enapps logo email

 

T: <a href="tel:%2B44%20020%208090%209222%20ext%201005" target="_blank">+44 020 8090 9222 ext 1005

M: <a href="tel:%2B44%20079%203923%200959" target="_blank">+44 079 3923 0959

E: [hidden email]

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:[hidden email]=[hidden email]] On Behalf Of Frédéric Clementi
Sent: 08 October 2014 08:05
To: Nhomar Hernández
Cc: OE Community [hidden email]
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.

 


camptocamp
INNOVATIVE SOLUTIONS
BY OPEN SOURCE EXPERTS
 
Frédéric Clementi
Project Manager 
Business Solutions
 
<a href="tel:%2B41%2021%20619%C2%A010%2041" target="_blank">+41 21 619 10 41
 
 

 

2014-09-29 13:54 GMT+02:00 Nhomar Hernández <[hidden email]>:

 

2014-09-29 4:26 GMT-04:30 lin.yu <[hidden email]>:

 

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?

 

 


 

--

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

 

Nhomar Hernandez

 


_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to     : [hidden email]
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp

 


_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to     : [hidden email]
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp

 


_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to     : [hidden email]
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp
Reply | Threaded
Open this post in threaded view
|

Re: [Openerp-community] odoo with a daily 50000 orders volume

Alberto Barrionuevo
In reply to this post by Frédéric Clementi
Hi Fréderic, Nhomar,

On 08/10/14 09:05, Frédéric Clementi wrote:
> Even with these tunings Odoo has no chance to handle such a volume of
> data. We are already struggling at 3000 SO/day.ç

    Doing changes in the OpenERP v6.0 code to optimize and remove
serious performance problems that it has, and using a middleware in
front of OpenERP (v60), we have been able to manage +55.000 orders each
12 hours with this server architecture [attached systems hardware diagram].

    Since our architecture is not "as big", we are sure that we can
multiply that number using more application servers, since, once
optimized. With improvements we get the initial software limit moved
from OpenERP to PostgreSQL, that is much more powerful in terms of
scalability than the standard OpenERP.

    The attached video shows the parallel creation of 32 SO in 25
seconds using the hardware architecture finally used in productive. It
means 0,78 seconds per SO.

    Indeed, the sales orders being created in this demo are heavier than
the standard ones, since they include some custom business processes to
be executed in OpenERP before the SO is confirmed in the sales flow.
Orders originally come mainly from a web trading platform from the final
customer, but also from other sources, all them passing through our
middleware for OpenERP done with Django. In the video we are simulating
the source with our own launching script used in QA tests.

    Disclaimer: This kind of solutions are on demand for each actual
case. They cannot be generalized. Some of the used optimization
techniques may be more generally applied. Additionally, Odoo v7.0 and
8.0 would need less work to escalate than the v6.0 that we "suffered".

    If anybody is really interested, with some days work in advance to
install again the whole solution, we can prepare and show a working
demo. But it would use our demo servers that are less powerful than the
attached productive architecture.

Best regards,
--
Alberto Barrionuevo, Director
OPENTIA Group
Odoo/OpenERP Silver Partner
T (+34) 918 38 38 58
F (+34) 944 34 00 77

         OPENTIA
Open Tech for Open Minds
      www.opentia.com

>
>
> *camptocamp*
>
> INNOVATIVE SOLUTIONS
> BY OPEN SOURCE EXPERTS
>
> *Frédéric Clementi*
> Project Manager
> Business Solutions
>
> +41 21 619 10 41
> *
> *
> www.camptocamp.com <http://www.camptocamp.com/>
>
>
> 2014-09-29 13:54 GMT+02:00 Nhomar Hernández <[hidden email]
> <mailto:[hidden email]>>:
>
>
>     2014-09-29 4:26 GMT-04:30 lin.yu <[hidden email]
>     <mailto:[hidden email]>>:
>
>
>         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
>     http://about.me/nhomar
>
>     <http://about.me/nhomar?promo=email_sig>
>
>
>     _______________________________________________
>     Mailing list: https://launchpad.net/~openerp-community
>     Post to     : [hidden email]
>     <mailto:[hidden email]>
>     Unsubscribe : https://launchpad.net/~openerp-community
>     More help   : https://help.launchpad.net/ListHelp
>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~openerp-community
> Post to     : [hidden email]
> Unsubscribe : https://launchpad.net/~openerp-community
> More help   : https://help.launchpad.net/ListHelp
>


_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to     : [hidden email]
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp
Reply | Threaded
Open this post in threaded view
|

Re: [Openerp-community] odoo with a daily 50000 orders volume

Alberto Barrionuevo
It seems that the attachments didn't pass the mail list filter. We will
publish them during the following hours.

Sorry,
//Alberto.

On 08/10/14 20:56, Alberto Barrionuevo wrote:

> Hi Fréderic, Nhomar,
>
> On 08/10/14 09:05, Frédéric Clementi wrote:
>> Even with these tunings Odoo has no chance to handle such a volume of
>> data. We are already struggling at 3000 SO/day.ç
>
>     Doing changes in the OpenERP v6.0 code to optimize and remove
> serious performance problems that it has, and using a middleware in
> front of OpenERP (v60), we have been able to manage +55.000 orders each
> 12 hours with this server architecture [attached systems hardware diagram].
>
>     Since our architecture is not "as big", we are sure that we can
> multiply that number using more application servers, since, once
> optimized. With improvements we get the initial software limit moved
> from OpenERP to PostgreSQL, that is much more powerful in terms of
> scalability than the standard OpenERP.
>
>     The attached video shows the parallel creation of 32 SO in 25
> seconds using the hardware architecture finally used in productive. It
> means 0,78 seconds per SO.
>
>     Indeed, the sales orders being created in this demo are heavier than
> the standard ones, since they include some custom business processes to
> be executed in OpenERP before the SO is confirmed in the sales flow.
> Orders originally come mainly from a web trading platform from the final
> customer, but also from other sources, all them passing through our
> middleware for OpenERP done with Django. In the video we are simulating
> the source with our own launching script used in QA tests.
>
>     Disclaimer: This kind of solutions are on demand for each actual
> case. They cannot be generalized. Some of the used optimization
> techniques may be more generally applied. Additionally, Odoo v7.0 and
> 8.0 would need less work to escalate than the v6.0 that we "suffered".
>
>     If anybody is really interested, with some days work in advance to
> install again the whole solution, we can prepare and show a working
> demo. But it would use our demo servers that are less powerful than the
> attached productive architecture.
>
> Best regards,
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~openerp-community
> Post to     : [hidden email]
> Unsubscribe : https://launchpad.net/~openerp-community
> More help   : https://help.launchpad.net/ListHelp
>


--
Alberto Barrionuevo, Director
Grupo OPENTIA
Odoo/OpenERP Partners
T (+34) 918 38 38 58
F (+34) 944 34 00 77

            OPENTIA
Ingeniería Informática en Abierto
         www.opentia.com

_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to     : [hidden email]
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp
Reply | Threaded
Open this post in threaded view
|

Re: [Openerp-community] odoo with a daily 50000 orders volume

Leonardo "LeartS" Donelli
2014-10-09 12:41 GMT+02:00 Alberto Barrionuevo <[hidden email]>:
> It seems that the attachments didn't pass the mail list filter. We will
> publish them during the following hours.


Hey Alberto, any news on the attachments? I am really interested in
what measures did you take to be able to manage that amount of data.

_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to     : [hidden email]
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp
Reply | Threaded
Open this post in threaded view
|

Re: [Openerp-community] odoo with a daily 50000 orders volume

Alberto Barrionuevo
Hi Leonardo,

On 10/10/14 19:00, Leonardo "LeartS" Donelli wrote:
> 2014-10-09 12:41 GMT+02:00 Alberto Barrionuevo <[hidden email]>:
>> It seems that the attachments didn't pass the mail list filter. We will
>> publish them during the following hours.
>
> Hey Alberto, any news on the attachments? I am really interested in
> what measures did you take to be able to manage that amount of data.
>
Here it comes. Sorry for the delay, yesterday we were "celebrating" our
National Day here.

Please, select the highest resolution to view the screencast in Youtube
or you won't be able to read the terminal windows:

https://www.youtube.com/watch?v=1Tan2qFhbAo

And here you have the other attachment with the hardware, operative
systems and networks architecture:

http://www.opentia.es/images/stories/diagramas/Odoo_HA_-_OpenERP_v60_systems_hardware_architecture-OPENTIA-20130722.png

We are explaining everything a little bit more in an article, including
a presentation that we did in the OpenERP Days 2012 in Brussels. I'll
come back when it is ready in English...

Best,
--
Alberto Barrionuevo, Director
Grupo OPENTIA
Odoo/OpenERP Partners
T (+34) 918 38 38 58
F (+34) 944 34 00 77

            OPENTIA
Ingeniería Informática en Abierto
         www.opentia.com

_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to     : [hidden email]
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp