Share via


LocalEseStoreSettings.EnableOverwriteOnUpdate Property

Definition

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