I had created range index on delete_flag and report_date, and i change my
xquery to
this:count(cts:search(collection('test')/patient/link/visit/lab_report[@delete_flag
= '0'],
cts:and-query(
(cts:element-attribute-range-query(xs:QName("lab_report"),xs:QName("report_date"),
">=", xs:dateTime("2010-09-25T00:00:00.000")),
cts:element-attribute-range-query(xs:QName("lab_report"),xs:QName("report_date"),
"<=", xs:dateTime("2014-09-25T00:00:00.000"))))));
and this query can work.
but if i execute the follow xquery, MarkLogic still will throw an
XDMP-EXPNTREECACHEFULL error:
cts:search(collection()/patient/link/visit/lab_report[@delete_flag = '0'],
cts:and-query(
(cts:element-attribute-range-query(xs:QName("lab_report"),xs:QName("report_date"),
">=", xs:dateTime("2010-09-25T00:00:00.000")),
cts:element-attribute-range-query(xs:QName("lab_report"),xs:QName("report_date"),
"<=", xs:dateTime("2014-09-25T00:00:00.000")))));
the above xquery will return a very large resut set, in this case, what can i
do to avoid the XDMP-EXPNTREECACHEFULL error
>
>Message: 1
>Date: Wed, 1 Jul 2015 10:58:24 +0530
>From: Indrajeet Verma <[email protected]>
>Subject: Re: [MarkLogic Dev General] XDMP-EXPNTREECACHEFULL error
>To: MarkLogic Developer Discussion <[email protected]>
>Message-ID:
> <cakwhaegeh70ro8wgqvmuv3jaqbcmv7u09gnxhnfxmfbv1or...@mail.gmail.com>
>Content-Type: text/plain; charset="utf-8"
>
>In Addition of Asit response,
>
>You should go with cts:element-values() and you should create cts:and-query
>and inside it cts:range-query for the dates and flag.
>
>Create range index for lab_report, report_date and delete_flag.
>
>Let me know if you want any help in creating query.
>
>Regards,
>Indy
>
>On Wed, Jul 1, 2015 at 10:45 AM, Asit Nautiyal <[email protected]>
>wrote:
>
>> Hi Zise,
>>
>> By observing below code, it will hit performance for sure and that's why
>> your are getting XDMP-EXPNTREECACHEFULL error.
>> To avoid XDMP-EXPNTREECACHEFULL error you have to tune your code. Use
>> cts:queries (like range queries and others) to get your result first and
>> then you can use count.
>>
>> Please go through the below link :
>>
>> https://docs.marklogic.com/guide/performance
>>
>>
>> Regards,
>> Asit Nautiyal
>> ------------------------------
>> Date: Wed, 1 Jul 2015 10:11:01 +0800
>> From: [email protected]
>> To: [email protected]
>> Subject: [MarkLogic Dev General] XDMP-EXPNTREECACHEFULL error
>>
>>
>> when i execute the following xquery , marklogic throw an
>> XDMP-EXPNTREECACHEFULL error:
>> count(for $i in collection('test')/patient/link/visit/lab_report
>> where $i /@report_date >= '2010-09-25T00:00:00.000' and $i/@ report_date
>> <= '2014-09-25T00:00:00.000' and $i/@delete_flag = '0'
>> return $i)
>>
>> I can not increase size of expanded tree cache, so what i can do to avoid
>> the XDMP-EXPNTREECACHEFULL error while the query resturn the very large
>> results
>>
>>
>>
>> _______________________________________________ General mailing list
>> [email protected] Manage your subscription at:
>> http://developer.marklogic.com/mailman/listinfo/general
>>
>> _______________________________________________
>> General mailing list
>> [email protected]
>> Manage your subscription at:
>> http://developer.marklogic.com/mailman/listinfo/general
>>
>>
>-------------- next part --------------
>An HTML attachment was scrubbed...
>URL:
>http://developer.marklogic.com/pipermail/general/attachments/20150701/e5ad4c84/attachment-0001.html
>
>
>------------------------------
>
>Message: 2
>Date: Wed, 1 Jul 2015 13:46:50 +0000
>From: Dave Cassel <[email protected]>
>Subject: Re: [MarkLogic Dev General] how to update the attribute of
> nodes?
>To: MarkLogic Developer Discussion <[email protected]>
>Message-ID: <d1b93d2e.cca51%[email protected]>
>Content-Type: text/plain; charset="us-ascii"
>
>To Asit's point, if you need to make an update like this across a large number
>of documents, take a look at Corb2<https://github.com/marklogic/corb2>.
>
>--
>Dave Cassel<http://davidcassel.net>, @dmcassel<https://twitter.com/dmcassel>
>Technical Community Manager
>MarkLogic Corporation<http://www.marklogic.com/>
>http://developer.marklogic.com/
>
>
>From: Indrajeet Verma
><[email protected]<mailto:[email protected]>>
>Reply-To: MarkLogic Developer Discussion
><[email protected]<mailto:[email protected]>>
>Date: Wednesday, July 1, 2015 at 1:21 AM
>To: MarkLogic Developer Discussion
><[email protected]<mailto:[email protected]>>
>Subject: Re: [MarkLogic Dev General] how to update the attribute of nodes?
>
>Hi Zise,
>
>You can try below code as well,
>
>xdmp:node-replace(/catalog/product/name/@language, attribute language
>{"chinese"})
>
>Regards,
>Indy
>
>On Wed, Jul 1, 2015 at 10:37 AM, Asit Nautiyal
><[email protected]<mailto:[email protected]>> wrote:
>Hi Zise,
>
>There are various ways to do this simple task. Find the below sample code :
>
>let $doc := fn:doc("/xmlFile.xml")
>let $oldNode := $doc/catalog/product/name[@language="en"]
>let $newNode := element {fn:local-name($oldNode)} { attribute language
>{"chinese"}, $oldNode/text()}
>
>return xdmp:node-replace($oldNode,$newNode)
>
>Above code will work as expected. But, if your database size is very huge and
>you want to perform such update on entire database then use cts:queries for
>better performance.
>
>
>Regards,
>Asit Nautiyal
>
>________________________________
>Date: Wed, 1 Jul 2015 11:50:02 +0800
>From: [email protected]<mailto:[email protected]>
>To: [email protected]<mailto:[email protected]>
>Subject: [MarkLogic Dev General] how to update the attribute of nodes?
>
>
>the xml document is:
><catalog>
><productdept="ACC">
><number>
>443
></number>
><namelanguage="en">
>Deluxe Travel Bag
></name>
></product>
></catalog>
>
>I want to update the attirbute language of node name to new value, after
>update operation, the name node is:
><namelanguage="chinese">
>Deluxe Travel Bag
></name>
>
>which function can do this in marklogic 8.0?
>
>
>
>_______________________________________________ General mailing list
>[email protected]<mailto:[email protected]> Manage
>your subscription at: http://developer.marklogic.com/mailman/listinfo/general
>
>_______________________________________________
>General mailing list
>[email protected]<mailto:[email protected]>
>Manage your subscription at:
>http://developer.marklogic.com/mailman/listinfo/general
>
>
>-------------- next part --------------
>An HTML attachment was scrubbed...
>URL:
>http://developer.marklogic.com/pipermail/general/attachments/20150701/0322e450/attachment.html
>
>
>------------------------------
>
>_______________________________________________
>General mailing list
>[email protected]
>Manage your subscription at:
>http://developer.marklogic.com/mailman/listinfo/general
>
>
>End of General Digest, Vol 133, Issue 1
>***************************************
_______________________________________________
General mailing list
[email protected]
Manage your subscription at:
http://developer.marklogic.com/mailman/listinfo/general
