How sluggish is a big xml file in combination with datasets?

21 Oct 2007 2:59 PM

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?

21 Oct 2007 3:21 PM

Kerry Moorman

PSiegmann,

How do you plan on dealing with concurrency?

Kerry Moorman

Show quote

"PSiegm***@mail.nu" wrote:

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

21 Oct 2007 4:11 PM

PSiegmann

On Oct 21, 5:21 pm, Kerry Moorman
<KerryMoor***@discussions.microsoft.com> wrote:

> PSiegmann,
>
> How do you plan on dealing with concurrency?
>
> Kerry Moorman
>
>
>

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