I have a set of documents that have volume and issue numbers represented as strings (e.g. 1, 10, 2, 23). If I use the following collation, I get a nice numeric sort without having to pad or otherwise normalize the data, but performance suffers. Is there an index I can add that would speed up the kind of sorting that this collation needs to do?

for $i in cts:search(doc()//article-title,"water")
order by $i/root()//volume collation "http://marklogic.com/collation/ en/MO"
return
$i/root()//volume


_______________________________________________
General mailing list
[email protected]
http://xqzone.com/mailman/listinfo/general

Reply via email to