Create new changelog tables

Support Developer
,
1

Hello all

I am looking for information and feedback.
We need to track some activities in our ERP for Procurement processes. So we need to develop a changelog table that will track Purchase Order changes: price changes, quantity changes, payment terms, send purchase orders…
Do we have feedback about the impact of this development in Tryton? Impact on performance for instance.

Thanks in advance for your help
Regards
G

2

Not sure to understand what you mean by changelog table but I guess it can be about activating the history on same models. This is have small cost that mainly add one SQL query per INSERT, UPDATE and DELETE queries on the model.

1 Like
3

thanks you very much Cédric. Any idea on the potential “issue of performance” when adding such history in the ERP?
If I have a lot of Purchase orders and a lot of Insert/update/delete activities on this items, that could create latency?

4

See my previous comment

1 Like