dataset.readxml performance problem Service Pack 3 beta

[obiwan1130]

I have a 100k xml file and I am attempting to read it into a dataset
using dataset.readxml

My xml file DOES have several nested nodes. However, none of the nodes
have more than 10 attributes. I am experiencing 10-12 seconds time to
load the xml document into the dataset.

Loading the schema first helps--but minimally (approx. 1-2 seconds)

We were previously using SP2, however, there is a known bug with SP2
where (under certain circumstances), only every other node is read
into the dataset.

Are there plans to improve the performance of the dataset.readxml
call.

Does anyone have thoughts regarding improving this performance issue.

Thanks in advance

 

[Ilya Tumanov [MS]]

That has been done in SP2 already, SP3 has no performance changes in that
area, just fixes like the one you've mentioned. V2 will be a bit better.

In our lab ~1 MB XML with 33 columns of various types (16 elements, 16
attributes and 1 primary key) and with 3 nested tables is loaded in 27
second with schema and in 81 seconds using inference (without schema).
That's on PXA 255 400 MHz device running PPC 2003.

10-12 seconds is a little too long (unless you're using slower device).
That might be because you're measuring first run (which would include
JITing time).
It also might be if you're using many DateTime columns.

Please see this for performance tips on DataSet XML:

http://groups.google.com/groups?q=DataSet+XML+performance+Ilya+group:microso
ft.public.dotnet.framework.compactframework&hl=en&lr=&ie=UTF-8&group=microso
ft.public.dotnet.framework.compactframework&selm=cjCaiutLDHA.2108%40cpmsftng
xa06.phx.gbl&rnum=1

Best regards,

Ilya


This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------