SQL CE Database on PocketPC

[Simone]

I'm afraid to ask: why are against putting a read/write database on a
storage card?
I could think of some reasons, but there are also some arguments for
doing so.

Primarily performance. This may become less of an issue with the new
faster cards (such as Sandisk Ultra and Extreme, or Lexar Pro). Another
factor is limited lifetime of a flash card especially with regard to
number of writes. Again, newer cards may be more robust

And the huge possibility of corrupting the entire thing if the device is put
to sleep or reset during a write, or if the card is pulled during a write.

--
Chris Tacke
Co-founder
OpenNETCF.org
Has OpenNETCF helped you? Consider donating to support us!
http://www.opennetcf.org/donate

OK, but where i storage the SLQCE mobile database????????
In RAM? And if i have a WARM boot?

Thanks.

Simon..

 

[Peter Foot [MVP]]

The answer is "it depends". But a good option if available on your target
hardware is built in ROM, e.g. \Storage\" etc as you have the benefit of
storage which persists over a soft or hard reset but isn't removable or
powered down by the SD interface. Then again there are size constraints as
most current devices have fairly limited ROM storage.

Peter

 

[chris-s]

Our app originally used an SD card to store the database on, but we
found that the SD cards were reaching their maximum-number-of-writes
within a few months resulting in corruptions. We then made the change
to work with the database being stored in the '\My Documents' folder
and regularly copying the database file to the SD card. This also
coincided with the availability of 'industrial grade' SD cards that
have a higher write-level, so these were also used.

This method suits the use of our app quite well since there is a
natural regular break point in its usage that allows the database to be
copied with little noticeable impact on the performance. If anything
was to get lost before the backup was made, it would not be too much of
a problem for it to be re-entered.

In our case the built-in permanent storage did not provide enough free
space, plus using a removable media allows for the data to be easily
retreived should the device get damaged or breakdown.

Chris