Question regarding SQL CE and flash storage

[Rune Lanton]

Hello!

I am developing an application for PPC2003, and I want too put my SQL CE db
on a flash card.

But I'm a little concerned about flash lifetime! Most flash memory have a
limit of 100.000 write/delete cycles, and I'm wondering if this could cause
any problems... Is there any kind of 'wear leveling' built into Windows CE
which affects the number of effective write/delete cycles, and if there is,
how effective is it??

While I'm at it, a little question on the side, anyone know if it's possible
to create an internet gprs connection programatically???
Thx in advance
Rune Lanton
Transportnett AS

[W.G. Ryan eMVP]

June - check out the SDF on Opennetcf.org for the GRPS issue - as far as the
storage card - I've had some deployed in the field for well over a year
without incident and havne't heard of anyone else having failures - but for
performance, I usually grab the data I need from the CE database and store
it in a datasets - manipulate it and send it back to the CE database only as
needed - that's just b/c the Open/Close of the connections can be a bit
slow...

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Rune Lanton" <Ru********@discussions.microsoft.com> wrote in message
news:10**********************************@microsof t.com...

Hello!

I am developing an application for PPC2003, and I want too put my SQL CE db on a flash card.

But I'm a little concerned about flash lifetime! Most flash memory have a
limit of 100.000 write/delete cycles, and I'm wondering if this could cause any problems... Is there any kind of 'wear leveling' built into Windows CE
which affects the number of effective write/delete cycles, and if there is, how effective is it??

While I'm at it, a little question on the side, anyone know if it's possible to create an internet gprs connection programatically???
Thx in advance
Rune Lanton
Transportnett AS

[Rune Lanton]

Thx for the input on the flashinputs!

Regarding the GPRS, I was wondering if there is any way to programmaticaly
create an entry in the ConnectionManager, dont want my users to have to do
this manually!

Rune

"W.G. Ryan eMVP" wrote:

June - check out the SDF on Opennetcf.org for the GRPS issue - as far as the
storage card - I've had some deployed in the field for well over a year
without incident and havne't heard of anyone else having failures - but for
performance, I usually grab the data I need from the CE database and store
it in a datasets - manipulate it and send it back to the CE database only as
needed - that's just b/c the Open/Close of the connections can be a bit
slow...

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Rune Lanton" <Ru********@discussions.microsoft.com> wrote in message
news:10**********************************@microsof t.com...

Hello!

I am developing an application for PPC2003, and I want too put my SQL CE

db

on a flash card.

But I'm a little concerned about flash lifetime! Most flash memory have a
limit of 100.000 write/delete cycles, and I'm wondering if this could

cause

any problems... Is there any kind of 'wear leveling' built into Windows CE
which affects the number of effective write/delete cycles, and if there

is,

how effective is it??

While I'm at it, a little question on the side, anyone know if it's

possible

to create an internet gprs connection programatically???
Thx in advance
Rune Lanton
Transportnett AS