Community mailing list archives

community@mail.odoo.com

Re: Odoo Performance and concurrency locks

by
Carlos Liébana Anero
- 09/15/2015 10:55:35
Hello,

It's really true that some things don't work smooth when dealing with a lot of information. It's not just a matter of server configuration but, as already stated, quality of developments (not only from SA). We all should have in mind that Odoo it's not anymore just an ERP of small companies, and the projects are getting bigger all around the world. See for example this bug filled today: https://github.com/odoo/odoo/issues/8537

Best regards.

2015-09-15 11:13 GMT+02:00 Alexandre Fayolle <alexandre.fayolle@camptocamp.com>:
On 14/09/2015 23:17, Antony Lesuisse wrote:
> That said, we will consider adding a separate append only table for last login 
> (actually it would be last presence it would be used for chat presence too) 
> because res.users is a foreign key to every row and i think most of the 
> concurrency issues comes from that.

I agree, and this is why we put up base_concurrency in the first place.

Thanks to Georges Racinet for explaining me why that combination of a
universal FK and a continuous update of the row was such a killer for
PostgreSQL.

> The patch would be very similar to base_concurrency module, the fonction 
> should be called when login and when longpolling on the bus (for chat and 
> notification). It would be append only to the table only if lasttime-now() is 
>  > that presence delay (maybe 5min). And we would GC it in a cron.

base_concurrency does not handle the longpolling bus. But it allows:

1. importing csv files in parallel
2. connecting as admin while long transactions are in progress (e.g. mrp
on a large db, large CSV file import)

Having these benefits natively in v9 would be great.


-- 
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

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




--
--------------------------

CARLOS LIÉBANA ANERO
Director | factorlibre.com
+34 635 86 67 92
@carlosliebana