Where to store SQLCE databases?

  • Thread starter Thread starter Jon Brunson
  • Start date Start date
J

Jon Brunson

We've got a project that uses SQLCE, and we really (and obviously) need
to store the data in non-volotile memory.

What's the best way to do this?

I've heard "horror" stories about SD Cards dieing after 6 weeks, because
their maximum number of writes have been exceeded, and storing the data
on the onboard ram of the device is stupid, as it would get lost during
a reset.

I'm just after a bit of advice on this front? Surely this problem has
been encountered (and solved) before?
 
We changed to store the 'working' database in '\my documents' but make
backups onto SD card at key points in the software particularly on
completion of each transaction. To date this has not failed us!

The cards we were using that caused the problem were 'blue' sandisk
cards, 128MB. Those that we purchased very early on have not shown the
problem, but it seems they changed something and later ones (cheaper)
exhibit the problem. As well as changing the database location we have
switched our customers to use the new 'industrial grade' sandisk cards
which are 'black' in color. These are supposedly produced to higher a
spec and _may_ work correctly when used as the location for the working
database, but this was not something we wanted our customers to test.

Some/most devices have some in-built non-volatile ram but it usually is
not very large.

Chris
 
Back
Top