How sluggish is a big xml file in combination with datasets? -- dotnet ado.net

PSiegmann NO[at]SPAM mail.nu
10/21/2007 7:59:15 AM

Hello,

I am currently working on a project which will run in an environment,
where the size of the database is very limited. That's why I thought
about relying in some parts entirely on xml files (and datasets) as an
DB replacement.

I.E.:

DataSet myDataSetToRead = new DataSet();

myDataSetToRead.ReadXmlSchema("c:\\abcd.xsd");
myDataSetToRead.ReadXml("c:\\abc.xml");

dostuff with the dataset data

etc.

Now, I will doing this only for the little used parts application,
where maybe 5 users at once will use it.

I know that this approach is slow compared to a real DB, but, what are
the other limitations? Is there a size limit? I mean, will it somehow
break after the file reaches 50 MB? And how much slower will it be,
compared to a DB? 10 times slower? More?

Kerry Moorman
10/21/2007 8:21:05 AM

PSiegmann,

How do you plan on dealing with concurrency?

Kerry Moorman

[quoted text, click to view]

PSiegmann NO[at]SPAM mail.nu
10/21/2007 9:11:07 AM

On Oct 21, 5:21 pm, Kerry Moorman
[quoted text, click to view]

Well, in the areas where I want to use this approach, only one user at
a time will write anything into the xml file.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about dotnet ado.net

dotnet ado.net : How sluggish is a big xml file in combination with datasets?