Saving XML datasets

I

Ishan Bhalla

Hello,

We are using datasets as in memory databases and are writing the contents of
the database to the disk at regular intervals using the WriteXML method.

The problem is that as the number of record increase so does the writing
time. Is there any way i can incrementaly write to the XML file?

Regards,
Ishan
 
W

William Ryan eMVP

XML is an very cool tool, but it's not the fastest thing in the world. I'm
not sure there's a whole lot you can do directly b/c it's going to take time
to serizliae and writeYou could use .GetChanges so you'd have a datatable
with only the changed rows. Then you could opt to consolidate them all into
one dataset at the end. I don't think this is going to do much overall b/c
the consolidation is going to take time
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a comment to a XML document: WriteXML 3
XML Problem as XMLDatasource from windowsapp to asp.net 2
Removing datasets from our architecture... 10
Store XML/XSD in SQL Server 2008 3
Save Listview items to Dataset > XML 2
Efficient way of querying datasets in c# 5
Problem with FOR XML clause 1
How to translate heterogenious XML files to typed datasets? 2

Top