Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Performance Question: .sdf vs SQL Express RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

     

    Does anyone know of a performance difference between an .sdf file vs SQL Express when using Microsoft Sync?  It seems that an .sdf would be easier to deploy and maintain but I have never worked with this technology so I am evaulating pros and cons for each datasource.
    • Moved by Max Wang_1983 Friday, April 22, 2011 6:49 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Tuesday, July 15, 2008 7:18 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

     

    Unfortunately we don't have such data at this moment. but I would think the performance on sqlcompact ( the .sdf file as single file db and light-weight in-process db engine ) and sql express will be vary from case to case and the major perf different is not in the sync component but at the db engine. i.e. the time spent on running the select and the insert/update/delete queries.

     

    thanks

    Yunwen

    Sunday, July 27, 2008 5:48 PM
    Moderator