Interests high-speed parameters of sample of data on great volumes. Thanks.
There is no general answer to the question which query interface shows the better performance. Therefore it would be helpful if you could be more specific.
Ok, I shall more certain. There is 1 million records in Doctype - Employee. What query will be faster:
- X-Query. Using REQUEST DOCUMENT(not using _cursor)
for $a in input()/Employee
What query will be faster and why?
If you just want to scan a large doctype, I assume there won’t be much difference between in XQuery and X-Query. Probably X-Query will be slightly faster. But if your doctype really contains millions of documents, your query will need so much time that this small difference will not matter.
I am possible once again I shall specify…
let $a := input()/Employee
return $a [position() >= 30000 and position() =< 40000 ]
The same question: that will work more quickly?
Excuse for importunity… :oops:
I think that the XQuery is faster because of certain optimizations that are done for position range filters.