PC Review


Reply
Thread Tools Rate Thread

DataSet Read/WriteXml Performance issue

 
 
=?Utf-8?B?R2VpciBTYW5uZQ==?=
Guest
Posts: n/a
 
      2nd Dec 2004
Hi!!!

I have a small dataset that i write to a .xml file.
The file is only 400bytes.

when i start the application and do a ds.ReadXml on the file, it takes 4
seconds.
Is it supposed to take this long ?
 
Reply With Quote
 
 
 
 
=?Utf-8?B?QWxleCBZYWtobmluIFtNVlBd?=
Guest
Posts: n/a
 
      2nd Dec 2004
Take a look at these tips from Iliya Tumanov:

http://groups-beta.google.com/group/...028d157d945a98

http://blog.opennetcf.org/ayakhnin/P...7-f337ab6d1feb

--
Alex Yakhnin, .NET CF MVP
www.intelliprog.com
www.opennetcf.org

"Geir Sanne" wrote:

> Hi!!!
>
> I have a small dataset that i write to a .xml file.
> The file is only 400bytes.
>
> when i start the application and do a ds.ReadXml on the file, it takes 4
> seconds.
> Is it supposed to take this long ?

 
Reply With Quote
 
Ilya Tumanov [MS]
Guest
Posts: n/a
 
      2nd Dec 2004
It takes a while (about 3-4 seconds) to JIT DataSet and XML code which is
rather big.
So, no matter how small your file is, it would take about 3-4 seconds to
load it the first time.
Second pass should be below 1 second for small files.

For bigger files, install SP2 (or 3 as soon as available) to improve
ReadXml() performance and use schema.
You can expect 1MB XML loaded in about 30 seconds on PXA255-400MHz and PPC
2003 device.

Best regards,

Ilya


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

--------------------
> Thread-Topic: DataSet Read/WriteXml Performance issue
> thread-index: AcTYfYQst4HO43CZSRijkSbCvjNydA==
> X-WBNR-Posting-Host: 83.108.31.143
> From: "=?Utf-8?B?R2VpciBTYW5uZQ==?=" <(E-Mail Removed)>
> Subject: DataSet Read/WriteXml Performance issue
> Date: Thu, 2 Dec 2004 06:45:07 -0800
> Lines: 8
> Message-ID: <75D7D2F0-ABE4-41F1-A5CB-(E-Mail Removed)>
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="Utf-8"
> Content-Transfer-Encoding: 7bit
> X-Newsreader: Microsoft CDO for Windows 2000
> Content-Class: urn:content-classes:message
> Importance: normal
> Priority: normal
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> Newsgroups: microsoft.public.dotnet.framework.compactframework
> NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> Xref: cpmsftngxa10.phx.gbl

microsoft.public.dotnet.framework.compactframework:66211
> X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework
>
> Hi!!!
>
> I have a small dataset that i write to a .xml file.
> The file is only 400bytes.
>
> when i start the application and do a ds.ReadXml on the file, it takes 4
> seconds.
> Is it supposed to take this long ?
>


 
Reply With Quote
 
egilh
Guest
Posts: n/a
 
      14th Dec 2004
Hi.
Another way to solve the performance problem is to write your own DataSet
loader.

I had worse performance problems and I ended up writing a class that
inherits from DataSet and adds a LoadFromCSV(...) method
[http://www.egilh.com/blog/archive/2004/11/28/363.aspx].

Cheers,
egilh

"Alex Yakhnin [MVP]" <(E-Mail Removed)> wrote in message
news:C82F5E84-69A2-4B36-AD89-(E-Mail Removed)...
> Take a look at these tips from Iliya Tumanov:
>
>

http://groups-beta.google.com/group/...028d157d945a98
>
>

http://blog.opennetcf.org/ayakhnin/P...7-f337ab6d1feb
>
> --
> Alex Yakhnin, .NET CF MVP
> www.intelliprog.com
> www.opennetcf.org

<!- cut -->


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
DataSet.WriteXML Vs. SQL Server 2000 XML performance issue??? manoj241176@gmail.com Microsoft ADO .NET 5 28th Jul 2006 06:35 PM
DataSet.WriteXML Vs. SQL Server 2000 XML performance issue??? Aryan Microsoft ASP .NET 0 28th Jul 2006 06:27 AM
Can't read xml to Excel (dataset.WriteXml) Morten Snedker Microsoft VB .NET 1 21st Apr 2006 01:47 PM
DataSet.WriteXml - can't read xml to Excel Morten Snedker Microsoft VB .NET 0 21st Apr 2006 11:42 AM
Can't read xml to Excel (dataset.WriteXml) Morten Snedker Microsoft VB .NET 1 6th Apr 2006 11:04 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:01 AM.