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.

 View Only
  • 1.  count performance

    Posted Wed February 28, 2007 11:31 AM

    Hi the experts !

    Actually, i have a bad performance with this counting request :

    count(
    for $a in input()/suiviPublication
    let $b := $a/publication[@archive=“N”]/diffusions/diffusion[@format=“LASER”]
    where $a
    and ( $b/diffusions/diffusion/@etat=“ERREUR” or $b/diffusions/diffusion/@etat=“ENCOURS” )
    return $a
    )

    For information, i tried the compound index with the 3 attributes
    (@archive, @format, @etat) without success.
    So i put a standard index on each one of these 3 attributes
    . But i also had the same performance.
    the disadvantage: i can’t change the schema’s structure, just putting
    index.

    Can i have any help ? a solution ?

    Thanks

    Tatoum


    #webMethods
    #Tamino
    #API-Management