locked
Performance Question: .sdf vs SQL Express RRS feed

  • Question

  •  

    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

  •  

    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