Mapping Lookup and performance?

[Former Member]

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

[bhavesh_kantilal · Accepted solution]

Hi,

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

Regards,

Bhavesh

[MichalKrawczyk]

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>

[Former Member]

Hi,

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

Regards

vijaya