[xquery-talk] get highest number

gonzberg at gmx.de gonzberg at gmx.de
Wed May 14 10:47:19 PDT 2008

my question concerns a specific query. The query below retrieves about 100.000 results. Without ordering (line 2) the query takes 1 sec, with ordering it takes 40 secs. What I want to retrieve is the highest "id" in my data. What I do is retrieve all ids, order, retrieve the last "id". Is there a faster way to achieve this in XQuery?

let $y := for $x in //@id
order by number($x)
return $x
return xs:string($y[fn:last()])

Thanks for your help! gonzberg
249 Spiele für nur 1 Preis. Die GMX Spieleflatrate schon ab 9,90 Euro.
Neu: Asterix bei den Olympischen Spielen: http://flat.games.gmx.de

More information about the talk mailing list