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

Reply via email to