[MarkLogic Dev General] Jumping deep into a large, ordered results list

[Liza Daly]

I need to be able to jump far into a results list, accurately, as fast 
as possible.

I'm getting marginal performance (~30 second response time) from a query 
like:

(for $d in cts:search(/doc, 'cat', 'unfiltered') return $d)[100000 to 
100020]

and about the same when I order by a range index:

(for $d in cts:search(/doc, 'cat', 'unfiltered') order by $d/sort return 
$d)[100000 to 100020]

(xdmp:query-trace() confirms my range index is working fine.)

But I'd love to get the performance of:

(cts:search(/doc, 'cat', 'unfiltered'))[100000 to 100020]

which comes back in less than 1 second.

Is there any chance of getting close to that performance on an ordered 
query, or one with any kind of FLWOR expression?

Thanks!

--Liza

--
Liza Daly
Senior Software Engineer
iFactory <http://www.ifactory.com/>