I am wondering what's the best practice for the problem I'm facing.
I'd like to use a scheduled provider that checks if a field is changed
in a table, but looking at examples it seems that there's no other way
but keeping a chronicle table with previous values.
Due to the large amount of data, it does not seem so performant.
So I was thinking at the possibility to trigger each change in sql
server, save data in a custom table and let the provider read this
user-created chronicle table.
Does it seem reasonable for you or is there a better way to do it?