Store DB on Card or in RAM

  • Thread starter Thread starter MDB
  • Start date Start date
M

MDB

Hello all, I am trying to figure out what the negative effects could be by
storing the sdf file on a memory card vs in ram. I have tested running the
db on the card and don't see a major performance difference so I was
wondering what other negative effects there could be.

My devices are intermec 76x's running WM2003 and I have a combination of
Sandisk Industrial Grade SD cards and regular SanDisk SD cards.
 
Before WM 5 the memory storage was not persistent except on a storage card -
in other words the user could lose his data if his battery ran out - so this
is a point in favor of using the storage card. The main disadvantage of
using the storage card is that sometimes they are slower to wake up than the
rest of the device, so your app might need to refresh in file handles,
database connections, etc., if they are no longer valid after waking up.
 
If you're using Intermec kit, then AFAIK, they are not WM5 yet, so you
will risk loosing your data if stored on internal memory. However,
running with your woking database on the SD card, may lead to
significantly shortened card life due to the level of sdf file updates/
rewrites during use. This will be somewhat dependant on the brand/type
of card and actual database usage. A happy medium maybe to have a
'working' copy of the db on internal memory with regular backups being
made to the SD card or see if you can split the db into two.

Chris
 
Yes, you are correct, we are not using WM5 and I have no plans upgrading all
of my devices (1500 though out the US). That is good to know about the
cards, currently I am using a combination of SanDisk 64 and 512 mb cards.
Have you had any experience with these? Also, the reason I am wanting to do
this is do to the users constantly cold booting the units which is causing
us to lose critical information even with backing up the dbs on the storage
cards on a regular basis.
 
Back
Top