IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
Expand all | Collapse all

update xquery takes a long long time

  • 1.  update xquery takes a long long time

    Posted Mon February 26, 2007 06:20 PM

    hello all,

    i am working with tamino 4.2.1 and a collection of 270,000 documents.

    It takes approximately 500 sec. to perfom a xquery update like :

    declare namespace tf=“http://namespaces.softwareag.com/tamino/TaminoFunction
    update for $q in input()/TEI.2/teiHeader
    let $id := tf:getInoId($q)
    where $id=(145365)
    do (
    replace $q/fileDesc/titleStmt/title/text() with tf:createTextNode(“malina”)
    replace $q/fileDesc/sourceDesc[@id=“orig”]/biblFull/title/text() with tf:createTextNode(“malina”)
    replace $q/fileDesc/sourceDesc[@id=“orig”]/biblFull/titleStmt/title[@level=“a”]/text() with tf:createTextNode(“malina”)
    )

    Is it an inefficient query ? What can i do to improve it ? Or to improve the tamino response time (i have already won 3 sec in changing the “XQuery document cache size” in my database properties but i’m not sure it’s really an improvement…) ?

    thnaks in advance
    thomas

    EDIT :
    The update is much quicker (approx. 1 sec) when replacing only one element (even with the relative // xpath) :

    declare namespace tf=“http://namespaces.softwareag.com/tamino/TaminoFunction
    update for $q in input()/TEI.2/teiHeader
    let $id := tf:getInoId($q)
    where $id=(145365)
    do (
    replace $q//titleStmt/author/text() with tf:createTextNode(“Bachmann, Ingeborg”)
    insert Mon Feb 26 17:50:35 CET 2007Tamino Java Client
    mod feld : //titleStmt/author -


    into $q/revisionDesc
    )

    What is so different between the two queries ?


    #webMethods
    #API-Management
    #Tamino


  • 2.  RE: update xquery takes a long long time

    Posted Wed March 21, 2007 04:45 PM

    hello all,

    i still have this problem of not knowing why the update of many elements when giving every absolute xpathes is some much longer (approx. 500 times) than giving only one xpath that “wraps” them all.
    Moreover, this “wrapping” workaround is only useful when i want to update several elements that are named the same (that happens in TEI documents) but not at all when i want to update, for example, one title and one author element on the same document.

    Does anyone has a lead on this ?
    Thanks in advance,

    Thomas


    #webMethods
    #API-Management
    #Tamino