Dataset/datatable serializing for SqlServer Session state

Discussion in 'ASP.NET 2.0' started by kenbusse, Jan 10, 2007.

  1. I will be supporting SqlServer Session state but am wondering what the best/fastest way will be of supporting the storage of my two datasets and a datatable; all items have only a few user/session related records.
    I am considering 3 options:
    1) using dataset or datatable's WriteXML/ReadXML methods while using a StringWriter to get/set a string value, something like this:
    Dim writer As New System.IO.StringWriter
    customerTable.WriteXml(writer, True)
    StoreInSessionState(writer)
    My understanding is that the serializing/deserializing of datasets/datatable is relatively slow for SqlServerState.
    2) use the SqlServerState's serializing
    3) use #1 above but save to a file on the web server.

    Thanks,
    Ken Bus
     

Share This Page