I have about 53,000,000 documents on my marklogic server, and each document contains one entry.
xquery version "1.0-ml";
declare namespace pa = "http://www.contata.com/pa";
let $query :=
cts:or-query((
cts:element-word-query(
xs:QName("pa:name"), "SMITH"
),
cts:element-word-query(
xs:QName("pa:address-1"), ""
),
cts:element-word-query(
xs:QName("pa:address-2"), ""
),
cts:element-word-query(
xs:QName("pa:address-3"), ""
),
cts:element-word-query(
xs:QName("pa:city"), ""
)
)) return
cts:search(fn:doc(),$query)[5100000 to 5300000]
when I execute the above request, which takes a long time to execute, and gives the following error
[1.0-ml] XDMP-EXTIME: cts: search (fn: doc (), cts: or-query ((cts: element-word-query (xs: QName ("pa: name"), "SMITH", ( "lang = en"), 1), cts: element-word-query (xs: QName ("pa: address-1"), "", ("lang = en"), 1), cts: element-word -query (xs: QName ("pa: address-2"), ", (" lang = en "), 1), ...))) - Time limit exceeded
but when I execute cts:search(fn:doc(),$query)[1000 to 2000], it succeeds.
: , RecordLoader.