Writing records from xml file into dataset

[Deshi]

Hi All,

I have an XML file with 50000 records, when i am trying to write into
DataSet through DataSet.ReadXml ("C:\..\Custome r.xml"). It takes more
than 30 minutes to write all records into DataSet. This affects lot
on my application performance. Is there any alternative to increase
the performance & reduce the time taken for writing...

Thanks in advance :-)

[Mark Rae [MVP]]

Re: Writing records from xml file into dataset

"Deshi" <deshi05@gmail. comwrote in message
news:51f9c0e4-0a22-4618-80c8-119c365702e0@c1 9g2000prf.googl egroups.com...

I have an XML file with 50000 records, when i am trying to write into
DataSet through DataSet.ReadXml ("C:\..\Custome r.xml"). It takes more
than 30 minutes to write all records into DataSet. This affects lot
on my application performance. Is there any alternative to increase
the performance & reduce the time taken for writing...

Is this a one-off exercise, or something you need to do on a regular
basis...?


--
Mark Rae
ASP.NET MVP

http://www.markrae.net

[Deshi]

Re: Writing records from xml file into dataset

On May 6, 2:42 pm, "Mark Rae [MVP]" <m...@markNOSPA Mrae.netwrote:

"Deshi" <desh...@gmail. comwrote in message
>
news:51f9c0e4-0a22-4618-80c8-119c365702e0@c1 9g2000prf.googl egroups.com...
>

I have an XML file with 50000 records, when i am trying to write into
DataSet through DataSet.ReadXml ("C:\..\Custome r.xml"). It takes more
than 30 minutes to write all records into DataSet. This affects  lot
on my application performance. Is there any alternative to increase
the performance & reduce the time taken for writing...

>
Is this a one-off exercise, or something you need to do on a regular
basis...?
>
--
Mark Rae
ASP.NET MVPhttp://www.markrae.net

Hi mark,

Now it seems to be bit ok with the performance, I am using
XmlTextReader API to read nodes comparativelly its much faster than
DataSet.ReadXml ()

Regards,
Deshi...