Community mailing list archives

community@mail.odoo.com

Odoo Performance and concurrency locks

by
Shawn Varghese
- 09/13/2015 15:52:13
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.