Hi,

Is it a good practice to have row VERSIONs on each table in your database (even if the application logic kinda restrict them to read-only, or just not so prone to concurrent updates)? Is there a big impact on performance if so?

thanks

No. Use VERSION only when necessary or when you fear concurrent modifications could cause a problem. In the case where your application handles it, you should be careful in that if your application becomes distributed one day and runs on more than one server, I am not sure how you prevent concurrent updates in application only code. The DB is the easiest and most preferred.




No. There is no big performance impact on doing version. However, this does not mean that you should use them everywhere.


If you found this helpful, dont forget to rate! :)