Apollo API Listing > sx

VB Declaration

Declare Function sx_CommitLevel Lib "Apollo9.dll"

(ByVal nNewLevel As Long) As Long

C Declaration

INT SDEAPI WINAPI sx_CommitLevel (INT nNewLevel);

Description

Set how and the SDE and Windows writes data to disk.

Parameters

nNewLevel: Value to set the commit level to. Possible values are 0,1 or 2.

0 – Full commit. Always write data to disk. Do not use SDE buffers and foce Windows to write any cached data. This offers the slowest performance (100x slower than level = 2 in some cases) but the data is guaranteed to always be saved upon each write.

1 – Normal commit. Do not use the SDE buffers, but do not force Windows to write the cached data. This offers very good performance and allows Windows to manage the data caching. (Usually 50-100% slower than level = 2)

2 – None. Let the SDE use its buffering mechanisms and do not force Windows to write the cached data. This offers the best performance (100x faster than level = 0 in some cases).

Return Value

Current commit level value.