webMethods

webMethods

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.  INOXME8504

    Posted Thu June 10, 2004 03:15 PM

    Hello,

    I have problem with XQuery and X-Query too.

    After a few minutes of processing queries, Tamino reports “XML maximum query duration exceeded, INOXME8504”.

    For some very short queries everything works fine. But for example the following X-query (and its equivalent XQuery too) returns the above error.
    /BIND-Submit[/BIND-Submit/BIND-Submit_interactions/BIND-Interaction-set/BIND-Interaction-set_interactions/BIND-Interaction/BIND-Interaction_a/BIND-object/BIND-object_short-label=‘105D_C’]

    I have checked this behavior with many queries.

    Can anybody help?

    Best Regards,
    Gopal.

    [This message was edited by Gopal on 10 June 2004 at 14:23.]


    #API-Management
    #webMethods
    #Tamino


  • 2.  RE: INOXME8504

    Posted Mon June 14, 2004 06:17 PM

    Hi,

    I think it will go (very much) faster when you define an index for the element BIND-object_short-label (and for any other element or attribute you are planning to search for.

    Let the Tamino Documentation guide you which index type to choose, as there are different for the datatypes and for word-fragment-search.

    Best regards, Andreas


    #API-Management
    #Tamino
    #webMethods


  • 3.  RE: INOXME8504

    Posted Wed June 23, 2004 10:16 AM

    Hello Andreas,

    I know that indexing would help in fast processing of queries and I did it already. But it doesn’t help at all.

    Can you please check the schema if there are any errors in indexing. Or any other ideas?

    Best Regards,
    Gopal.
    bindSchema.tsd (687 KB)


    #API-Management
    #Tamino
    #webMethods


  • 4.  RE: INOXME8504

    Posted Thu July 01, 2004 01:19 PM

    Hello,

    I found out a solution to this problem. I was using a “=” operand which caused that the indexing did not taky effect. Now I am using a “~=” operand and the query is very fast.

    Best,
    Gobal


    #API-Management
    #Tamino
    #webMethods