|
[XQuery Talk Mailing List Archive Home] [By Date] [By Thread] [By Subject] [By Author] [Recent Entries] [Reply To This Message] get highest numbergonzberg at gmx.de gonzberg at gmx.deWed May 14 10:47:19 PDT 2008
Hello, 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
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Cast Your Vote
We need your help – Vote for DataDirect XML Products!
Winners and finalists announced at SOA World Conference in November. Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|







