If there's no 'where' or 'order by', and the return isn't interesting,
skip the FLWOR expression.
xdmp:directory('/TITLE/', 'infinity')/title/titlekey
However, XDMP-EXPNTREECACHEFULL generally means that you're trying to
boil the ocean. That's usually a bad idea: try to write a more selective
query. Maybe you could get the titlekeys in batches of 10, or 25, or
even 1000?
Be cautious about increasing the expanded tree cache size. If you
increase it too much, your server may run out of physical memory: that's
much worse than an XDMP-EXPNTREECACHEFULL error.
See http://marklogic.markmail.org/search/?q=EXPNTREECACHEFULL for
similar threads.
-- Mike
On 2009-10-09 08:34, Sakthikumar, Vasu wrote:
Hello All,
I am getting a tree cache error when I run the query below.
xquery version "1.0-ml";
for $b in xdmp:directory('/TITLE/', 'infinity')/title
return $b/titlekey
Error
-----
XDMP-EXPNTREECACHEFULL:
for $b as item()* in xdmp:directory("/TITLE/", "infinity")/child::title return
$b/child::titlekey
-- Expanded tree cache full on host
Is there a better way to write the query?
Thanks
Vasu
_______________________________________________
General mailing list
[email protected]
http://xqzone.com/mailman/listinfo/general
_______________________________________________
General mailing list
[email protected]
http://xqzone.com/mailman/listinfo/general
