[XQuery Talk Mailing List Archive Home] [By Date] [By Thread] [By Subject] [By Author] [Recent Entries] [Reply To This Message]

get highest number

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


  get highest number
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!

Buy Stylus Studio Now

Cast Your Vote

We need your help – Vote for DataDirect XML Products!

  • Best SOA or XML site

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!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2007 All Rights Reserved.