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