FLASH vs. Volatile memory

[Ian Williamson]

Greetings,

I am looking for some suggestions on the best way to
manage my data store.

Currently, I am keeping my SQL CE DB in FLASH memory, but
it is painfully slow. My other option is of course to
keep it in volatile memory, but the likelihood of data
loss is simply too great (mostly from power loss).

I am about to embark upon a new strategy. Have the
working copy in volatile memory and have a backup copy in
FLASH which is updated on a background thread. This is
going to take several days to implement, so I thought I
would ask the user community how they have dealt with
similar issues.


Cheers, Ian Williamson

 

[Alex Feinman [MVP]]

Why not to copy SDF file to the flash area periodically?

 

[Ian Williamson]

Hi Alex,

That is another option I have been considering, but I am
concerned with the slow down copying a 15Mb file every 5
minutes or so would cause. Are you aware of any
incremental file copy libraries or programs for CF?

Cheers, Ian

 

[Paul G. Tobey [eMVP]]

The problem is that the file content is changing during the copy, isn't it?

Paul T.

 

[Ian Williamson]

That is almost a certainty.

I am sure that I am not the only person to be dealing
with this conundrum, so how are others managing it?

Ian

 

[Steve Maillet \(eMVP\)]

They put the file in RAM or they put it in FLASH. But not both. Or they use
a faster medium like a micro.