Devart Forums

Is there any way to set DBPROP_SSCE_TRANSACTION_COMMIT_MODE to DBPROPVAL_SSCE_TCM_FLUSH when working with SQL CE databases through your dbExpress Driver for SQL Server?

Or are there other ways to make sure the changes gets commited to disk at once without waiting for the SQL CE flush interval?

For the time being, there is no way to set DBPROP_SSCE_TRANSACTION_COMMIT_MODE to DBPROPVAL_SSCE_TCM_FLUSH using dbExpress driver for SQL Server. Such functionality is implemented in SDAC. In SDAC, there is the TMSCompactConnection component that has the TransactionCommitMode property. TransactionCommitMode is used to specify the way the buffer pool will be flushed on transaction commit. To use synchronous commit to disk (DBPROPVAL_SSCE_TCM_FLUSH), you should set TransactionCommitMode to cmSynchCommit. For more information about SDAC, please refer to http://www.devart.com/sdac/
We will investigate the possibility to add such functionality in dbExpress driver for SQL Server.