Skip to Content
Menu
This question has been flagged
1 Reply
826 Views

Sorry, I have a none-IT back ground, so I will try to explain this as best as I could.


We are trying to add 8 to 10 extra fields in each of the following modules:
Sales, Purchase, Inventory, Accounts.


Fields such as Warning Method, Warning Message, Payment Term, Is_Shipped, Payment Status, ETA, and etc


Most of these fields are native fields in odoo but some are from different modules, so currently they are calculated fields. For the efficieincy of the operation, we need to have all these fields  as STORED fields in each module, so we run some auotmated actions with these fields being accessible.

Eg, Payment Status will (from Accounting) will trigger status update in Sales Order.

Currently, Payment Status (from Accounting) is not available for lookup in Sales module.


Our IT has advised against this pattern of behaviour as it might contributes to slowing down the system as our operation and the database grows.


So, my question is, would by adding 8 to 10 fields make us in trouble as our IT has perdicted?

(... before Quantum computer would become available......)

Avatar
Discard
Best Answer

I don't think adding 8-10 new fields will slow down the odoo server. but again it depends on the logic/calculation you are using to get the value of the calculated fields. don't forget to try to make the fields storable because if the field is calculated fields and if it is not stored, odoo will calculate the value each time you try to access the record (in list view, odoo displays by default the first 80 records, so for all these 80 records odoo will calculate the values that cause a performance problem) but if the calculated fields are storable, it will not cause a major performance problem

Avatar
Discard
Author

Thank you, I'll feedback to my boss, especially about making those stored fields!! Thank you

Related Posts Replies Views Activity
0
Jun 23
3
0
Mar 15
3637
0
Mar 15
3177
1
Aug 24
446
0
Jan 24
5883