Community mailing list archives
Re: sales order confirmation v9: speed issueby
1 mn for 100 lines is long but not so surprising. The problem is that you need a x10 or x20 improvement because there are only 1440 mn in a day.I guess you already tuned postgresql, updated postgresql version and use multiple workers.Olivier Dony made the best presentation about performance tuning in 2014. Still valid imho. It shows there are not much we can do when the server is properly set up.My understanding is that Odoo is slowly suppressing its workflow engine which sucks in particular for -e-commerce.Nevertheless I know many on this list have delt with performance issues and may share good advices. I stay tuned.2016-01-29 10:42 GMT+01:00 Gaspard Dessy <email@example.com>:
We are deploying on v9 so haven't tested similar case on other version.
The order confirmation (amongst others) does
- Create procurements
- Create stock moves
What takes most of the time is create procurement.On Jan 29, 2016 5:09 PM, "Dominique Chabord" <firstname.lastname@example.org> wrote:Odoo is known to be slow at order validation step.Was is slow also with V7 and V8 or just with V9 ?2016-01-29 9:52 GMT+01:00 Gaspard Dessy <email@example.com>:Hello,On v9 we have performance issue on order confirmation: over 1 min server processing for an order with 100 lines. We have up to 3000 sales order per day (in total 50-200k sales order lines) and worry about server performance.Any trick or experience to share?