Hi, XDMP-EXPNTREECACHEFULL can be avoided by increasing Expanded Tree Cache size from Admin console.
The problem i can see is that you are selecting a large subset of data in memory and then predicating. The better approach i can think of is, create metadata in document for property::myns:year, index it, use search API to sort the content. I would not suggest querying property as it is not efficient. Hope this helps! Mihir ------------------------------ > > Message: 3 > Date: Fri, 31 May 2013 11:12:46 -0500 > From: Mauricio Valderrama Fonseca <[email protected]> > Subject: [MarkLogic Dev General] Sort by element in > document-properties > To: MarkLogic Developer Discussion <[email protected]> > Message-ID: > < > caa_rxwqjqfsu4voxf9esddksblrk+_+wc0cx+8_bgmgfjg7...@mail.gmail.com> > Content-Type: text/plain; charset="iso-8859-1" > > Hi All, > > I'm using ML 5.0-5, and I'm trying to make a sort by properties and as the > search:search doesn't support this kind of sort, I have a code like this: > > (for $result in cts:search(doc(), cts:collection-query("content")) > order by $result//property::myns:year > return $result)[1 to 20] > > The myns:year element is an element-range-index, it works when the result > size is short but when there are many results I get an > XDMP-EXPNTREECACHEFULL. > When the error is not thrown, the performance is quite bad. > When I use a document element (element-range-index) it works. > Is there any way to avoid the error? How could I Improve the sort > performance? Thanks > > > > -- > Atentamente > Mauricio Valderrama Fonseca > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > http://developer.marklogic.com/pipermail/general/attachments/20130531/b6b82cf8/attachment-0001.html > > ------------------------------ > > Message: 4 > Date: Fri, 31 May 2013 17:19:00 +0000 > From: Eric Bloch <[email protected]> > Subject: [MarkLogic Dev General] Norm's recent post on timezones is a > great read > To: MarkLogic Developer Discussion <[email protected]> > Message-ID: > <93acebc222c637479703aca6268e6716278...@exchg10-be01.marklogic.com > > > Content-Type: text/plain; charset="windows-1252" > > I highly recommend this recent post from Norm. > > http://norman.walsh.name/2013/05/30/timezones > > It's just as much about a use case for MarkLogic geo and reverse queries? > as it is about timezones. > > Eric > > > Eric Bloch > Director, Community > MarkLogic Corporation > > desk +1 650 655 2390 | mobile +1 650 339 0376 > email [email protected]<mailto:[email protected]> > web developer.marklogic.com<http://developer.marklogic.com> > twitter @eedeebee > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > http://developer.marklogic.com/pipermail/general/attachments/20130531/b6312a93/attachment-0001.html > > ------------------------------ > > _______________________________________________ > General mailing list > [email protected] > http://developer.marklogic.com/mailman/listinfo/general > > > End of General Digest, Vol 107, Issue 97 > **************************************** >
_______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
