RE: Storing XSL Documents In Database

[Kay Michael <Michael.Kay@xxxxxxx>]

It seems to me that
> there are 3 good solutions to do this:
>     1.  Serialize the Document object to a byte array,
>     2.  Write the document out to a byte array, 
>     3.  Write out the Document to a String, and store each line of the
> document as a varchar in the database,

In my own experiments some time ago I found that the most efficient serial
format for a document was - guess what - XML. I found it was significantly
quicker to reparse the XML than to "unserialize" the serialized DOM, largely
because the XML is far smaller.

I've used the technique of breaking up the XML document into logical units
(e.g. a single entry in a dictionary) and storing each as an XML fragment in
a VARCHAR field, having copied any attributes that are significant for query
purposes into separate columns of the table.

Another technique you don't mention is to store the DOM as persistent
objects in an object database. I haven't had the chance to compare that. It
should work well in theory.

Mike Kay


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list