get highest number

[gonzberg at gmx.de]

Thanks Michael,
this makes it slightly faster, but still takes around 30 seconds...

Then it is probably better to retieve all IDs and to process the max value in my application afterwards.


-------- Original-Nachricht --------
> Datum: Wed, 14 May 2008 09:26:29 +0100
> Von: "Michael Kay" <http://x-query.com/mailman/listinfo/talk>
> An: http://x-query.com/mailman/listinfo/talk, http://x-query.com/mailman/listinfo/talk
> Betreff: RE:  get highest number

> > Is there a faster way to achieve this in XQuery?
> 
> max(//@id)
> 
> Michael Kay
> http://www.saxonica.com/
> 
> > 
> > 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 
> > _______________________________________________
> > http://x-query.com/mailman/listinfo/talk
> > http://x-query.com/mailman/listinfo/talk
> 
> 
> _______________________________________________
> http://x-query.com/mailman/listinfo/talk
> http://x-query.com/mailman/listinfo/talk

-- 
Psssst! Schon vom neuen GMX MultiMessenger gehört?
Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger