Re: Looking for Fast Database

Tech-Archive recommends: Fix windows errors by optimizing your registry



Hi Doug,

a couple of years before, I developed an applicaiton for WinCe 4.2 with a
database-file (sdf) on a SD card. At first, everythink was fine, but a few
month later, we had problems wirh corrupted sdf-files on the SD cards.
We had at lot of trouble with that failure. I don't know exactly why that
happens. Some people say, that it is something with the power managment. I
think, it is better to be careful.

Regards,

Carsten Unterberg | Test-Framework
http://test-framework.blogspot.com/



"Doug" <joker@xxxxxxxxxxx> schrieb im Newsbeitrag
news:2aa6df32-143b-4024-a056-81d2172ce105@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Carsten,

Can you explain exactly why an SD card (or any removable flash memory)
shouldn't be used for the database file?

On Jan 19, 7:54 am, "Carsten Unterberg"
<carsten.unterb...@xxxxxxxxxxxxxx> wrote:

btw, you shouldn't store database files (*.sdf) on a sdcards. it can be
dangerours and can corrupt your database.



.



Relevant Pages

  • Re: SQL CE 3.5 and Data Loss on SD Card
    ... sure the SD card is ready before we attempt data access. ... You might consider changing the flush interval on the connection string to ... with a database on SD card I would be greatful. ...
    (microsoft.public.sqlserver.ce)
  • Re: SQL CE 3.5 and Data Loss on SD Card
    ... devices we have experienced only one corrupted SDF database. ... I attribute our success to opening a connection just before every DB access ... some code that checks to make sure the SD card is ready before attempting ... The message was checked by ESET Smart Security. ...
    (microsoft.public.sqlserver.ce)
  • Re: SQL CE 3.5 and Data Loss on SD Card
    ... with a database on SD card I would be greatful. ... devices we have experienced only one corrupted SDF database. ... I attribute our success to opening a connection just before every DB access ...
    (microsoft.public.sqlserver.ce)
  • Re: Desperate for business bank account
    ... When a card is first issued it would be checked with the ... Why does it have to be checked against a very large database? ... renewals, updates and corrections (including invalid entries from input), you ... so the local subset can be gathered in advance. ...
    (uk.consultants)
  • Re: Desperate for business bank account
    ... When a card is first issued it would be checked with the ... Why does it have to be checked against a very large database? ... so the local subset can be gathered in advance. ... Peter Saxton from London ...
    (uk.consultants)