1. Mailing Lists
  2. Contributors
  3. Perhaps an Odoo Performance Issue ?!

Contributors mailing list archives

contributors@odoo-community.org

Browse archives

Proposing myself as banking-maintainers PSC

Request for l10n-serbia

Avatar

Perhaps an Odoo Performance Issue ?!

by
sewisoft UG , Stefan Wild
- 05/10/2022 14:28:51
Dear all OCAler,

I have noticed a performance behavior with Odoo, and want to clarify if I am wrong, or not :)

In my opinion, Odoo clears too often the complete LRU Cache. So all ir.qweb, ir.model.access, and so on, has to be reloaded.
In that case, you find the Log message: "At least one model cache has been invalidated, signaling through the database."

Here just two examples when this happens:

 - Deleting a record which has got an IrModelData Entry e.g. through exporting
   https://github.com/odoo/odoo/blob/c9609c62efe163901f8c2b1a30355b60dd34ad51/odoo/models.py#L3695
   https://github.com/odoo/odoo/blob/c9609c62efe163901f8c2b1a30355b60dd34ad51/odoo/addons/base/models/ir_model.py#L1968

 - Changing a user-defined default value
   https://github.com/odoo/odoo/blob/c9609c62efe163901f8c2b1a30355b60dd34ad51/odoo/addons/base/models/ir_default.py#L32


In our scenario( ~1.000.000 Sale Orders, ~350 Modules installed), this results, that an F5 Browser Refresh need's ~5 seconds.
Without clearing the LRU Cache, the reload is done in < 1 second.

My question:
Is this really necessary to invalid all ir.qweb, ir.model.access data, when I just change one default value of a user, or delete one IrModelData entry ?

Is there a way to change this behavior ?

Thank you all and Best regards,
Stefan



Vielen Dank und viele Grüße

Stefan Wild
Geschäftsführer
sewisoft.de - Logo

sewisoft GmbH
Örtleinsweg 39
96148 Baunach

info@sewisoft.de
Tel. +49 (0) 160 / 99 11 25 69
www.sewisoft.de

Sitz der Gesellschaft: Baunach
Registergericht: Amtsgericht Bamberg, HRB 8508
Geschäftsführer: Günter Selbert, Stefan Wild



Follow-Ups