Community mailing list archives

community@mail.odoo.com

Re: Odoo Performance and concurrency locks

by
Camptocamp France SAS, Alexandre Fayolle - Camptocamp
- 09/14/2015 02:31:44
On 13/09/2015 21:57, Shawn Varghese wrote:
> Hello everyone,
> 
> I am fast approaching large volumes of data for one of our POS
> implementations and I would like to optimize Odoo and Postgres
> performance before the issue gets out of hand.
> 
> Right now, an immediate concern is the concurrency locks in the DB. Once
> a lock occurs, Odoo only tries upto 5 times to resolve it and the delay
> between each retry is too small. The code for this is in the osv.py file
> and I tried to manually increase the *MAX_TRIES_ON_CONCURRENCY_FAILURE*
> value and restarted the server. But it did not seem to have any effect.
> Odoo still only tries 5 times. How can I update the osv file then?
> 
> Also, to increase the number of HTTP workers, it is just a simple case
> of giving a non-zero number to the *workers* parameter in the config file?
> 
> How exactly does one achieve load balancing?
> 
> I would be very grateful to anyone who can help me out here.
> 
> I have gone through Olivier Dony's presentation on Deploying Odoo and it
> provides very interesting insights but unfortunately, I have not been
> able to implement them.

Install base_concurrency (https://github.com/OCA/server-tools) this will
alleviate lots of issues.


-- 
Alexandre Fayolle
Chef de Projet
Tel : +33 4 58 48 20 30

Camptocamp France SAS
Savoie Technolac, BP 352
73377 Le Bourget du Lac Cedex
http://www.camptocamp.com