none
XML and DataSet (using XML as database) RRS feed

  • Question

  • i try to use XML as my database, and i found DataSet work well with it.

    but i now sure is the dataSet suitable for my need.

    i have to working with quite large XML Database, about 15 tables, and each table may contain more than 50000 records
    is it possible to use DataSet.ReadXml(), dataSet.WriteXml()

    i mean the memory usage and performance.

    i dont know the the scene behind how DataSet handle the data.
    is it load all data into memory when i call ReadXml()? or just read from disk when i search it (DataSet.Select())?


    tahnkyou very much
    Friday, January 4, 2008 4:52 AM

Answers

  • DataSet reads all the data into the memory.

    It is quit efficient when data have relational structure (set of tables). It can uses indexes for searching.

    Make sure you define schema for the XML or DataSet so it can convert numeric values to CLR numeric types. This gives more efficient search and storage.

     

    The only way to answer your question is measure on real data and real environment.

    If your data is relational and you want all data to be in memory DataSet may be  a good choice.

     

    Moving thread to DataSet specific forum.

     

    Friday, January 4, 2008 5:16 AM