logo       

RE: xquery with large xml file: msg#00060

Subject: RE: xquery with large xml file
> well, i tried the top down approach code but where can i pass 
> my file name let $j:= doc("book_sample.xml")

Just replace 

local:pathOfNodes('', /*)

with

local:pathOfNodes('', doc("book_sample.xml")/*)

I was using the context node as input primarily because it makes it easier
to measure tree construction as a separate part of the query cost (having
said which, I need to check if the figures I quoted yesterday included tree
construction or not!)

Michael Kay
http://www.saxonica.com/

> 
> --- Michael Kay <mhk-uGS4jv4rpPNaa/9Udqfwiw@xxxxxxxxxxxxxxxx> wrote:
> 
> > > I finally got around to running this against the
> > 100Mb data
> > > file with Saxon.
> > > It produces the same size output (don't know why
> > the
> > > expansion factor should be different on the 10Mb
> > file) in 5
> > > minutes 45 seconds. 
> > > 
> > 
> > 
> > The equivalent non-recursive query
> > 
> > //*/string-join(ancestor-or-self::*/local-name(),
> > '/')
> > 
> > (actually a pure XPath expression) takes 2 mins 23 seconds.
> > 
> > I also tried a top-down approach, to reduce the number of redundant 
> > string concatenations and calls on local-name():
> > 
> > declare function local:pathOfNodes($parentPath as 
> xs:string, $node as
> > node()) as xs:string* {
> >     let $this := concat($parentPath, '/',
> > local-name($node)) 
> >     return ($this, $node/*/local:pathOfNodes($this,
> > .))
> > };
> >     
> > local:pathOfNodes('', /*)
> > 
> > This took 3m 29s.
> > 
> > Michael Kay
> > http://www.saxonica.com/
> > 
> > 
> 
> 
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection 
> around http://mail.yahoo.com 
> _______________________________________________
> talk-KUd/JJajPrLQT0dZR+AlfA@xxxxxxxxxxxxxxxx
> http://xquery.com/mailman/listinfo/talk



<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

Recently Viewed:
boot-loaders.gr...    php.pear.genera...    debugging.valgr...    kde.redhat.user...    text.xml.xsl.ge...    culture.languag...    hardware.microc...    java.servicemix...    redhat.release....    web.zope.plone....    user-groups.lin...    opendarwin.webk...    video.mjpeg.use...    sysutils.bcfg2....    encryption.gpg....    lx-office.devel...    xfree86.forum/2...    mail.mutt.devel...    acpi.devel/2003...    qnx.openqnx.dev...    network.irc.irs...    freebsd.devel.m...   
Home | blog view | USPTO Patent Archive | advertise | OSDir is an inevitable website. super tiny logo

Free Magazines

Cisco News
Receive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business.
subscribe

Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field.
subscribe

The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business.
subscribe

Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company.
subscribe

Total Telecom Total Telecom is "The Economist of the communications industry".
subscribe