.NET CF Slow in ADO.NET Update

  • Thread starter Thread starter Evan Camilleri
  • Start date Start date
E

Evan Camilleri

In SQLCE.

I have a dataset of about 1000 records. I update each and every record.

When I execute the Update method it takes 6 minutes!

Quite along time for 1000 records?!
 
And can we ask why you'd be updating 1000 records individually rather than
in bulk? Is your database indexed?


--
Chris Tacke - Embedded MVP
OpenNETCF Consulting
Managed Code in the Embedded World
www.opennetcf.com
--
 
since i am receiving an XML file which contains the updates of my dataset.
-
most probably yes i have an issue with a particular index (will check on
that)

thanks for now
 
Could it be because of a slow memory source? Where is your database
stored? Storage Card, IPSM, etc?
 
Back
Top