P
PSiegmann
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?
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?