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:\..\Customer.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 :-)

Jun 27 '08 #1

Subscribe Reply

1052

Mark Rae [MVP]

"Deshi" <de*****@gmail.comwrote in message
news:51**********************************@c19g2000 prf.googlegroups.com...

I have an XML file with 50000 records, when i am trying to write into
DataSet through DataSet.ReadXml("C:\..\Customer.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

Jun 27 '08 #2

Deshi

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

"Deshi" <desh...@gmail.comwrote in message

news:51**********************************@c19g2000 prf.googlegroups.com...

I have an XML file with 50000 records, when i am trying to write into
DataSet through DataSet.ReadXml("C:\..\Customer.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...

Jun 27 '08 #3

Similar topics

2752

Writing XML to html with XSLT

by: VMI | last post by:

I'm having trouble writing several records from an XML file into an html file. The problem is that it only outputs one record to the html file. I need to export all the records in the xml file to...

C# / C Sharp

2186

When adding lots of records, do you still use INSERT INTO?

by: Mike Hnatt | last post by:

My goal is to get data from an XML file into a couple of tables in an Access database. The XML file is a little complex so I need control over what I do (I can't just read it into a dataset). ...

ASP.NET

1178

Datasets - writing only changed records to xml file

by: Paul | last post by:

Hello, I have a dataset which i'm loading from an xml file (using ds.ReadXml() ) and I'm wondering how I can write back only the changed records to the xml file instead of saving the whole file...

Visual Basic .NET

1323

Writing to two tables

by: Paul | last post by:

I have an application that I am tryign to modify, I never wrote the original so need help with my modifications. Currently the app reads and writes to an Access database with one table 'pupils'...

Visual Basic .NET

5056

Is the reading/writing to the registry slow?

by: UJ | last post by:

I have a system that has five programs that all communicate with each other via Message Queues. Works well. One program is a watchdog that will make sure the others are up and going. Currently I...

C# / C Sharp

1924

Writing XML File from Dataset

by: sparty1022 | last post by:

Read many of the posting but still doen't understand the process. I have a dataset with child records. I have a specific XML "Account.XSD" format that I need to write this out to. How do I...

.NET Framework

1509

writing to XML file

by: slinky | last post by:

I'm struggling with what should be a very basic .aspx/XML issue. I have an XML file. I have a textbox for a user to enter data and a button to submit the data. I don't wont the user to see the...

ASP.NET

1656

XML File - reading and writing

by: maw | last post by:

Hi, could somebody point me in the right direction for adding, removing and modifying nodes in an xml file programatically using vb.net (.net framework 2.0)? I have an xml file in the following...

ASP.NET

2974

Performance issue whilst writing to Excel

by: =?Utf-8?B?ZmhpbGxpcG8=?= | last post by:

We have a code snippet that downloads data to Excel. it is writing row by row. This causes a performance issue. Any ideas on how to speed this up will be appreciated. Please find below an...

C# / C Sharp

7245

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7144

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7356

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7427

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

7085

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

5069

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

3214

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

785

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

449

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General