save XmlDocument as SQL image data?

[Jack Fox]

I'm still new to Xml, but finding it very useful.

Conceptually what I want to do is compress an XmlDocument, save it to SQL
Server as image data, read it back and restore it to an XmlDocument.

I'm a bit bewildered by the choices available (XmlSerialization, XmlWriter,
Xml on SQL Server) and do not have any experience with them, so I was
wondering what is the best way to do this?

[Oleg Tkachenko]

Jack Fox wrote:

I'm still new to Xml, but finding it very useful.

Conceptually what I want to do is compress an XmlDocument, save it to SQL
Server as image data, read it back and restore it to an XmlDocument.

I'm a bit bewildered by the choices available (XmlSerialization, XmlWriter,
Xml on SQL Server) and do not have any experience with them, so I was
wondering what is the best way to do this?

I believe the best, the simplest and probably the most effective is just
to serialize XmlDocument to string using Save() method. And to resore it
back just load XmlDocument from the string.
--
Oleg Tkachenko
http://www.tkachenko.com/blog
Multiconn Technologies, Israel

[Jack Fox]

Thanks, but all of the overloaded Save methods send it to some sort of
writer or file. The OuterXML property should suffice, then use the LoadXml
method to load it.

I thought some sort of easy compression method would be available, my
documents can get quite large.

"Oleg Tkachenko" <oleg@NO_SPAM_PLEASEtkachenko.com> wrote in message
news:ey*************@TK2MSFTNGP11.phx.gbl...

Jack Fox wrote:

I'm still new to Xml, but finding it very useful.

Conceptually what I want to do is compress an XmlDocument, save it to SQL Server as image data, read it back and restore it to an XmlDocument.

I'm a bit bewildered by the choices available (XmlSerialization, XmlWriter, Xml on SQL Server) and do not have any experience with them, so I was
wondering what is the best way to do this?

I believe the best, the simplest and probably the most effective is just
to serialize XmlDocument to string using Save() method. And to resore it
back just load XmlDocument from the string.
--
Oleg Tkachenko
http://www.tkachenko.com/blog
Multiconn Technologies, Israel

[Oleg Tkachenko]

Jack Fox wrote:

Thanks, but all of the overloaded Save methods send it to some sort of
writer or file. The OuterXML property should suffice, then use the LoadXml
method to load it. OuterXML, Save, WriteTo, whatever - it's about the same, namely DOM serialization.
I thought some sort of easy compression method would be available, my
documents can get quite large.

If XML is N Mb, then in-memory XmlDocument may be roughly 3N or 4N. Compress
serialized string instead.
--
Oleg Tkachenko
http://www.tkachenko.com/blog
Multiconn Technologies, Israel

[Jack Fox]

I cannot find any Method in the DotNet Framework that does compression,
except related to Passport and encryption of short strings (not megabytes).

Any suggestions?

Even without compression I have greatly enhanced the efficiency (elapsed
time) of my application by saving the OuterXML to SQL Server. The CPU used
for compression and decompression may actually prove detrimental, now that I
think of it. I will eventually have to implement selective cache purging,
but I'm not there yet.
"Oleg Tkachenko" <oleg@NO_SPAM_PLEASEtkachenko.com> wrote in message
news:eb**************@TK2MSFTNGP11.phx.gbl...

Jack Fox wrote:

Thanks, but all of the overloaded Save methods send it to some sort of
writer or file. The OuterXML property should suffice, then use the LoadXml method to load it. OuterXML, Save, WriteTo, whatever - it's about the same, namely DOM

serialization.

I thought some sort of easy compression method would be available, my
documents can get quite large. If XML is N Mb, then in-memory XmlDocument may be roughly 3N or 4N.

Compress serialized string instead.
--
Oleg Tkachenko
http://www.tkachenko.com/blog
Multiconn Technologies, Israel

[Oleg Tkachenko]

Jack Fox wrote:

I cannot find any Method in the DotNet Framework that does compression,
except related to Passport and encryption of short strings (not megabytes).

Any suggestions?

Google for compression tools for .NET, there are a lot of them. I've used this
one:
http://www.icsharpcode.net/OpenSourc...b/Default.aspx

--
Oleg Tkachenko
http://www.tkachenko.com/blog
Multiconn Technologies, Israel