Hi
I have a database which consists of above 20,000 documents, each of around 2-10
kilo bytes. I get the 20000 documents by following query: let $uri :=
cts:uri-match('products/documents/*.xml') let $doc := fn:doc ($uri)
products/documents contains all the xml documents. we need to build csv file
from this record set, with each xml documents beingone row in the csv file. but
since the size of document is too large so we are recieving an error message '
XDMP-EXPNTREECACHEFULL' (I think the document was tried to store in main
memory, which was not allowed by the system).
What can be other work around? Can we add streaming of result ? If yes please
provide one example so that I can grab it.
Otherwise, Can we convert documents part by part to csv and then output to HTTP
output stream ?
Increasing the size of cache from admin console is not a solution because the
document size may grow in future.
thanks,ranjan. _______________________________________________
General mailing list
[email protected]
http://developer.marklogic.com/mailman/listinfo/general