SQL CE commit and flushing

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
glennvisma
Posts: 4
Joined: Wed 06 Mar 2013 14:55

SQL CE commit and flushing

Post by glennvisma » Wed 06 Mar 2013 15:00

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?

AndreyZ

Re: SQL CE commit and flushing

Post by AndreyZ » Thu 07 Mar 2013 09:59

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.

Post Reply