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.  Speed with Native Schema

    Posted Wed August 28, 2002 11:54 AM

    Hi everybody!

    I have a Native Schema with 500,000 docs. A query (SW_CUSTOMER [SWCUSTOMERID = 4668]) against this schema is too slow.

    Though, this query in a schema mapped to Oracle is very fast. I think it happened because the table in Oracle use indexes that makes the query faster.

    Does anybody knows how can I define my Native Schema or the Database in order to resolve this speed problem?

    Thanks.


    #webMethods
    #API-Management
    #Tamino


  • 2.  RE: Speed with Native Schema

    Posted Wed August 28, 2002 02:11 PM

    Did you define any kind of index for “SWCUSTOMERID” in the Tamino Schema ?


    #API-Management
    #webMethods
    #Tamino


  • 3.  RE: Speed with Native Schema

    Posted Tue September 03, 2002 09:54 AM

    Yes, i tried to make an index in the key field, but it doesn’t run quicklier.


    #webMethods
    #API-Management
    #Tamino


Related Content