given a doctype with about 9000 instances and a query:
let $b := input()/Street
return $b[position() < 5]
response is almost instantaneous. Changing this to :
count(let $b := input()/Street
return $b[position() < 5])
and the response drops to 13 - 14 seconds - the time to scan the all the documents in the doctype. Why?
Thanks, eh!
Douglas Kelly,
Principal Consultant
Software AG, Inc
Sacramento, California
#API-Management#webMethods#Tamino