|
Posted by Ginny Caughey [MVP] on January 31, 2007, 1:01 pm
Please log in for more thread options
Mark,
The product name ended up being SQL Server Compact Edition or SSCE. The
overhead is around 2 mb so not a big deal by today's standards and not
requiring a storage card unless you'll have loads of data. The general rule
of thumb is that if you'll have more than 2 mb of data, use SSCE, but it
also works just fine with less. Or more accurately, you might not want to
use XML or CSV if you'll have more than 2mb of data for performance reasons.
--
Ginny Caughey
Device Application Development MVP
>I am working on a program that will have both a desktop component and
> a Device component. The idea is to allow a person to add data to
> their phone and then sync it with the desktop thru Active Sync. At the
> same time I want them to be able to enter the data on their PC and
> have it go to the program on the phone.
>
> What is a recommended way to store the data - SQL Everywhere/Mobile/
> Whatever it is called now, XML, CSV, etc?
>
> There will be a search function (drop down list) that allows them to
> choose a set of values that they already have, or add a new set of
> values with a name that they choose, and the ability to edit and save
> existing values as they want. I would do this all with SQL but I am
> not sure what the overhead is and how much space that installation
> will take. I don't want to count on them having a storage card, so
> the smaller the footprint the better.
>
> I welcome your suggestions!
>
> Mark
>
| 
XML Sitemap