Best choice of data storage on PDA in C# (short term/ long term)

[Daniel Passwater via DotNetMonster.com]

I am a newbie, so please be patient. I am working on an app that will extract data from an embedded system via serial connection. I need to get the data as fast as possible and then go back and assimilate it after I've disconnected.

What is the best way to store this data for both the temporary and long term?

Thanks to anyone who helps.

*****************************************
* This message was posted via http://www.dotnetmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.dotnetmonster.com/Uwe/Abuse.aspx?aid=8200b714ce074f33875eabde58bd1f64
*****************************************

 

[Ginny Caughey [MVP]]

Daniel,

How much data do you anticipate working with? Flat files as suggested by
Jordan can work quite well, and if they are small you may not even need to
worry about indexing. I use this approach in some of my apps as well.

If you expect to have a lot of data however, then it might be simpler to
just use SqlCE for storage and let SqlCe worry about the indexes.

 

[Boris Nienke]

I am a newbie, so please be patient. I am working on an app that will
extract data from an embedded system via serial connection. I need to
get the data as fast as possible and then go back and assimilate it
after I've disconnected.

- Flat Textfiles (good for not too much data)
- XML files (could hold more complex datastructures but slow with too many
data)
- Database

For Database:
- the SQLServerCE is included but very heavy (i think). Need to installed
etc.
- db4o (www.db4o.com) is cool. Just build up an object to hold you data and
then store/retrieve them.
- PocketAccess Database files. Were the "standard" on PocketPC but not with
..NetCF. Look at www.inthehand.com - they have a wrapper to let you use such
simple database files. You can work with SQL then too i think. But limited
to ~15000 records per table/file - then the whole thing will slow down

Boris