This question has been flagged
2 Replies
5533 Views

What is the purpose of tracking values in odoo
Setting >Technical>Tracking Values
Is this logs badly effects slowness in db?

Avatar
Discard
Best Answer

Hi,

1. The purpose is to capture the data like when and which user changed the field, ie new data and old data in your model.

2. It is given when you define a field using track_visibility='onchange' , and track_visibility='always'.

3.Yeah, it consumes more of your database size. If you have a high end server with maximum ram and CPU, you may enable tracking as you like.

4. But if you go with medium level , it is not advisable to enable tracking for all the fields in a model,

you may enable only for the master tables and in transaction forms you can enable it for priority fields like state and amount_total, customer etc.

5. Enabling tracking for all fields and capturing logs for its do increase the db size and cause slowness in db.

6. It is suggested to clear your logs then and then, maybe after one or two years once.

Thank you

Avatar
Discard
Author

Thank you so much for the detailed answer karthikeyan.