By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,667 Members | 2,618 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,667 IT Pros & Developers. It's quick & easy.

Question regarding SQL CE and flash storage

P: n/a
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

Jul 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Jul 21 '05 #2

P: n/a
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


Jul 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.