Skip to Content
avatar image
Former Member

Mapping Lookup and performance?

Hi all,

I'm thinking about using mapping lookup (JDBC)

Does anyone have experience with the performance of this metod?

would it be better to use the BPM?

Thanks 😊

Thomas Nørmark

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Nov 22, 2006 at 12:28 PM

    Hi,

    Comparing BPM vs JDBC Lookup, Using Jdbc look up's would be better in terms of performance .

    Regards,

    Bhavesh

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 22, 2006 at 12:32 PM

    hi,

    DB lookup in mapping will always be more efficient

    then the BPM but the questions are :

    - how will you see handle the errors in this?

    - you will not be able to see this query (in message monitoring - as you do in case of BPM

    Regards,

    michal

    -


    <a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Here is an eg: /people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

      Regards

      vijaya