[xquery-talk] xquery with large xml file

Michael Kay mhk at mhk.me.uk
Thu Apr 13 16:11:03 PDT 2006

It doesn't make sense to try and answer this question without knowing what
product you are using.

The query doesn't look particularly problematic. With Saxon it runs against
the 10Mb XMark database in about 20 seconds, without any special memory
settings. The output file is about 23Mb.

Michael Kay

> -----Original Message-----
> From: talk-bounces at xquery.com 
> [mailto:talk-bounces at xquery.com] On Behalf Of fatma helmy
> Sent: 13 April 2006 14:27
> To: talk at xquery.com
> Subject: [xquery-talk] xquery with large xml file
> dear all
> i received the following code to return all nodes with
> their full paths
> declare function local:pathOfNode($node)
> {if(empty($node/..)) then ""  else
> concat(local:pathOfNode($node/..), "/",
> local-name($node))};
> let $j:= doc("book_sample.xml")
> let $paths := for $n in  $j//* return
> local:pathOfNode($n)
> actually it worked well with xml file size 1M and
> worked slow with xml file 4M and died with file 11M
> can xquery deal with large xml file?
> do i need index to speed up my operation?
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
> _______________________________________________
> talk at xquery.com
> http://xquery.com/mailman/listinfo/talk

More information about the talk mailing list