Time limit exceeded in Markligic Cts: Search

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.

+3
2

"" , "search: search".

, , , . , 500000- , 500000 , 500000 . 100 , 5000 .

+4

200.000 . . Query Console CQ, , cts: , 200k docs.

!

+1

All Articles