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.  Query response time

    Posted Thu May 22, 2003 07:16 PM

    Hi, all,

    I have a question on query response time:
    When I run both string and integer queries of the same selectivity against the same database, the resulting time for integer query is longer than the string query. Can anybody tell me why it is?

    PS: I have run these queries against both indexed and un-indexed data and the results didn’t change either.

    Thanks!


    #API-Management
    #webMethods
    #Tamino


  • 2.  RE: Query response time

    Posted Thu May 22, 2003 07:59 PM

    Hello Jazz,

    I must admit that I don’t have any immediate ideas about this!

    Could you please post a small example (schema + queries) and let us know which Tamino version you are using?
    I’ll have a look into it and see if I can help.

    Greetings,
    Trevor.


    #API-Management
    #webMethods
    #Tamino