store bulk data in datatable RRS feed

  • Question

  • Hi,

    I am creating application in which I have to read thousands of XML files and then store in datatable is this correct approach or I should use database to store data?.  

    Thursday, May 9, 2013 5:35 PM


  • It depends what is the purpose of saving the records. Datatable is a memory variable, saving records into the datatable means saving them into memory.

    If you want to save the records into datatable for processing and then you do not need them anymore, then yes a datatable would be an acceptable choice.

    Else if you want to persist data, then you want to save it into a database.

    Ali Hamdar (alihamdar.com - www.ids.com.lb)

    • Proposed as answer by Mike Feng Friday, May 10, 2013 7:34 AM
    • Marked as answer by Mike Feng Wednesday, May 15, 2013 11:53 AM
    Thursday, May 9, 2013 5:50 PM