LocalEseStoreSettings.EnableOverwriteOnUpdate Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Enables in-place replace of value (versus insert/delete) during update operation. Maps to JET_bitSetOverwriteLV on the local ESE store.
public bool EnableOverwriteOnUpdate { get; set; }
member this.EnableOverwriteOnUpdate : bool with get, set
Public Property EnableOverwriteOnUpdate As Boolean
Property Value
Returns true
if overwrite on update is enabled; otherwise, false.
Remarks
Enabling this setting is useful in cases where certain access patterns can cause the ESE database file to grow on disk even though the logical data size remains same. For example, a large number of transactions getting rolled back or a series of updates made by some transactions while other transactions remain open as updates are happening.
Note that enabling this setting may increase version store usage and the value of MaxVerPages may need to be increased.
Applies to
Azure SDK for .NET