The question of whether BLOBs (XML document or picture) should be stored inside or outside Cache has been discussed many times. I don't think that there is a clear winner in all circumstances. Maybe someone with more experience in this area than me would care to comment on the pros and cons.
Just as another thought. A possibility might be to create Cache persistent classes which match the documents and use %XML.Reader to create class instances for these documents. Then XMLExport (%XML.Writer in later versions) can be used to recreate the documents. This gives you full object access to the document contents and SQL search on the document contents. We do not support Xpath for selecting and retrieving the documents. You would need to use SQL on the fields in the containing class. We've had internal discussions about xpath and xquery, but there are no plans at this time for implementation. Marvin "Serhat Inan" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello Marvin, > > Thank you vey much. I have worked on that sample and my xml import for > Person class also well done. > > If we go one step more I have an important question for us: > > We have XML documents confirmed to special DTDs. Does it make sense to store > our XML documents into Cache DB instead of file system (may be the pictures > also)? Will that improve the performance on retrieving the documents and > searching on documents? > > Also does Cache support "Xpath" syntax for retrieving the XML documents > stored in DB? (Or the instances of classes that hold the documents.) > > Regards > Serhat > > "Marvin Tener" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > Use %XML.Reader class. See /csp/samples/xmlimport.csp for sample code. > > > > I would suggest that you create a class method in Cache that does all the > > work and then just call this class method from VB with the XML string. > > > > Marvin > > > > "Serhat Inan" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED] > > > As I understand Cache allows to import and export XML data on the > classes > > > that extends XMLAdaptor. I have managed > > > to export the instances as XML for the Sample.Person class using > > > XMLExportToString method. (With VB6.0). > > > However I could not find the way how to import an xml string that > > correlates > > > to an instance of the class? (Using VB6.0 if possible). > > > > > > Serhat > > > > > > > > > > > >
