Which Lookup Gives More performance?!!

[Former Member]

Hey,

Can anybody suggest me the which kind of lookups ( Jdbc/RFC/Value mapping ) gives some good performance on Idoc to JMS or JMS to Idoc scenarios.

Please suggest me any performance tuning kind of stuff on above scenarios too.

-S

[Former Member · Accepted solution]

i would prefer RFC Lookups.

[Former Member]

Hi Stallin

It will be better to provide your requirement and system information as their are lot of factors which drive this selection.

Already very good explanation is given by Pooja !!!

For IDOC to JMS or vice versa what you want to achieve using Lookups or Value mappings?

Thanks

Gaurav

[Former Member]

Hi Mr S,

Comparing Value mapping to Mapping look up ( RFC/JDBC) is somewhat like comparing oranges to apples. They are similar in end sought, but the means at which they provide the data and the scope of input and output values vary greatly between the two mechanism.

To decide which mechanism to use, some of the factors to consider are as follows :

Amount of Data: Is there a small or large amount of data to maintain ?

Frequency of Change: Is the data static or dynamic?

Location of Data: Is the data externally maintained ?

Input/Output Value Ratio: Is the input/output value ratio 1/1?

Backend Application Type: Is the backend an SAP system, database system, or application system that provides web service.

Value Mapping (Integration Directory UI)

• Dataset is small, static, not externally maintained.

• Input/Output value ratio is 1/1.

Mapping look up

• Dataset is large, dynamic, and externally maintained

• Input/Output value ratio is n/n.

• A value mapping function is available in the backend or can easily be implemented.

• Backend is an SAP system (RFC) , database system (JDBC), or web services provider(SOAP).

Thanks,

Pooja