Reading XML stored as Blob into Dataset

[Spike]

Hi all,
Ive been successful in trying to read a blob XML (XML
is stored as blob in database) into a Dataset. However the
process seems to be very slow. Ive used the following
method.

Fetch data into a DataTable
Read the blob column into a byte array
Write byte Array to String
Read the String into StringReader
Use DataSet.ReadXML to read from the StringReader

Can anyone give some better options to speed up the
process.

Thanks in Advance
Spike.

 

[Sahil Malik]

In the steps you mentioned, did you run any semantics on time taken per
process?

- Sahil Malik
You can reach me thru my blog at
http://www.dotnetjunkies.com/weblog/sahilmalik