DataTable.ReadXml performance problem

[Sagaert Johan]

Hi

I want to read an XML file with CF , the XML is about 660Kb and is taking a
long time to load .

In the emulator it takes about 45 seconds, on a real CE5 device (@667Mhz) it
still takes more then 5 seconds. and on a real smartphone (HTC S710)
it takes more then 16 sec.

I wonder if this poor performance is due to file io or is the Xml
tablereader the culpritt ?

I have a feeling like reading a floppy disk on an an old 80286 machine ...

Any hints or alternatives to read the xml ?

(I basically am reading a a datatable from xml that has been writen
previously by a full framework app )

Johan

 

[Christian Resma Helle]

Hi Johan,

Using ADO.NET for managing XML will result in very poor performance in the
..NETCF. The fastest way is to use an XmlReader.

Here's a link to an old .NETCF article entitled "Developing well performing
..NETCF applications":
http://msdn2.microsoft.com/en-us/library/aa446542.aspx

And another useful FAQ on the .NETCF 2.0 performance and working set
http://blogs.msdn.com/netcfteam/archive/2005/05/04/414820.aspx

And a set of webcasts regarding .NETCF performance
http://updates.zdnet.com/tags/Microsoft+.NET+Compact+Framework+and+high-performance.html