tuning ssce 3.5 OLE DB database properties RRS feed

  • General discussion

  • I'm currently using version 3.5 Sql Server CE on an embedded platform using OLE DB and I'm looking into using the Provider-specific Data Source Properties to optimze the database performance.  Specifically, the DBPROP_SSCE_MAXBUFFERSIZE and  DBPROP_SSCE_FLUSH_INTERVAL properties. Typically, there are no more than two connections.  What, if any, changes in query execution updates can I expect from changing these values from their defaults?  What are the minimum and maximimum values?  Also, I'm  not using a tempfile.  Are there advantages to using one?  Thanks.
    Thursday, October 11, 2012 9:26 PM

All replies

  • Maybe your question is not suitable here....

    Please not forget mark your answer, and unmark your disagreed point.

    Tuesday, October 16, 2012 11:07 AM
  • Hi,
    Your issue may has not a solid answer; I think it should be better if we change the thread type to General Discussion.
     Thanks for your understanding and active participation in the MSDN Forum.

    Elegentin Xie [MSFT]
    MSDN Community Support | Feedback to us

    Thursday, November 8, 2012 8:51 AM