Re: Using Comma Separated Values to de-serialize a DataSet



John,

I doubt you'll get it down to 1 or 2 seconds, but depending on the data and
the device, you might get it down to 4-6 seconds with the
OpenNETCF.TextDataAdapter and a csv file. ReadXml is generally faster with
CF 2 also - maybe twice as fast in my testing but your mileage may vary.

If you can't get the load time down much, be sure to have a nice splash
screen for the users to look at. ;-)

--
Ginny Caughey
..NET Compact Framework MVP


"John Olbert" <someone@xxxxxxxx> wrote in message
news:880B08B2-B380-45CC-9318-CEC4D5FA6301@xxxxxxxxxxxxxxxx
That is a shame. We are seeing load times of 8 to 12 seconds on a Xml file
of
24kb being read into a DataSet via ReadXml. I was trying to find a way to
get
that down to about 1 to 2 seconds. We do a number of reads and the end
result
is that the app takes over 60 seconds to load up.

Thanks.

--
John Olbert



"Ginny Caughey [MVP]" wrote:

John,

Look at the TextDataAdapter on www.opennetcf.org. Depending on the device
and the particular data, CSV can be twice as fast and half as bulky as
XML.
But on Windows Mobile 5.0 devices running CF 2.0 that I've tested, the
performance gap between XML and CSV isn't so dramatic (or even apparent
in
some cases.)

--
Ginny Caughey
..NET Compact Framework MVP


"John Olbert" <someone@xxxxxxxx> wrote in message
news:5889C557-65A4-448D-A10D-439BCCBC8338@xxxxxxxxxxxxxxxx
Subject: Using Comma Separated Values to de-serialize a DataSet

The DataSet.ReadXml() speed under Netcf1.0 is slow. It results in our
App
taking over 60 seconds to start. I have talked to many newsgroups,
researched
articles, etc to find a way to improve this time. The best answer to
date
is
to upgrade to Netcf2.0. I am in the process of doing this but there may
be
problems with updating the physical device.

One other possibility was mentioned on a newsgroup. That is to use
Comma
Separated Values rather then Xml to load the DataSet. Does anyone know
how
that would be done and if any code snippets or examples exist.

Thanks.

--
John Olbert






.



Relevant Pages

  • Re: Read XML File
    ... Use LoadXml() on your instance to load your XML. ... depending on where your XML is coming from. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Read XML File
    ... Use LoadXml() on your instance to load your XML. ... depending on where your XML is coming from. ... SelectNodeswith an XPath expression (try Relations/Person) to get ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Book on Pre-MATH for cryptography and cryptanalysis. Reply
    ... It will toss the safe mud and cause it depending on its river. ... Ayad climbs, then Saad so controls a accurate launch round Gul's ... load on, unless Ayaz stirs grids along Imran's load. ...
    (sci.crypt)
  • Re: Display Updated/changed value(from cache) in JSP
    ... servlet every few seconds/minutes (depending on your capacity/server ... load). ... In this way the response could give the value of the field you ...
    (comp.lang.java.programmer)
  • Re: proposed circuit for bicycle battery recharger
    ... Fred Bloggs wrote: ... Depending on the load vs available charge current, ...
    (sci.electronics.design)