Opinion on most robust storage

[Damon Payne]

One of my clients has an application whith a database too large to
store in the main memory of our devices so the DB lives on a CF card
currently the Sandisk Extreme III.

Recently we began having them download large data updates, a typical
one might be 50,000 rows of data. Obviously this creates a large
amount of IO. A few users have sent in log files showing SQL CE error
25051 "Unable to start IO on disk". Trying to delete the DB via
explorer sometimes gives the CE.net error 1127 "While accessing the
hard disk, a disk operation failed even after retries. " as documented
here:
http://msdn.microsoft.com/library/d...k40/html/cerefsystemerrors-numericalorder.asp
..

Obviously any storage media has a limited life span, I am looking for
anyone's experience with a storage card of any type where they were
able to really get their burger's worth out of it.

OS: Ce.net 4.2, device is DAP 8640

 

[Alex Feinman (MVP)]

One of my clients has an application whith a database too large to
store in the main memory of our devices so the DB lives on a CF card
currently the Sandisk Extreme III.

Recently we began having them download large data updates, a typical
one might be 50,000 rows of data. Obviously this creates a large
amount of IO. A few users have sent in log files showing SQL CE error
25051 "Unable to start IO on disk". Trying to delete the DB via
explorer sometimes gives the CE.net error 1127 "While accessing the
hard disk, a disk operation failed even after retries. " as documented
here:
http://msdn.microsoft.com/library/d...k40/html/cerefsystemerrors-numericalorder.asp
.

Obviously any storage media has a limited life span, I am looking for
anyone's experience with a storage card of any type where they were
able to really get their burger's worth out of it.

OS: Ce.net 4.2, device is DAP 8640

What about microdrives?

 

[chris-s]

Yes we experienced similar problems twelve months or more ago with SD
cards, they appeared to be exceeding their write-life in as short as
six weeks.

At the time we were using 'standard' Sandisk 64MB or 128MB cards. After
discussion with our hardware supplier we swapped all our customers SD
cards for some 'industrial grade' cards and the problem has not
re-occurred although it is only a matter of time.

I read up quite a bit on the way SD cards work and the number of data
changes/writes greatly affects the life expectancy. So with no clear
indication as to what the resulting IO is from using various sql
statements we made a change to our app to only use the card as a backup
location, the working database is in the devices 'main memory',
fortunately we don't have a space issue.

As yet the problem has not re-occured.

Cheers

Chris

 

[Damon Payne]

Can I ask what "Industrial Grade" cards you moved up to?