What are the advantages and disadvantages of using Optimistic Concurrency?
The disadvantage is that the data integrity could be compramised if not used with caution. The advantages are numerous, first one being allowing mulitiple transactions to access same data concurrently. When UpdateModifiedFields option is used: This can give a significant performance boost for following reasons: 1) Very often your data access is read-only. In such cases, not sending an update to the database is obviously a big win. We have seen order-of-magnitute performance boosts from this single optimization. 2) Many databases write logs depending on which columns were modified. For example, SQL Server will log the update if a TEXT or IMAGE field is updated, regardless of whether the column’s value actually changed. Note that the database often does not (or cannot) distinguish between updating a column to hold the same value it used to hold (which is what occurs with “UpdateAllFields”), and actually modifying the column’s value. Suppressing the update for the case where the value did
