Data Access Problem with Lookup tables

[Former Member]

Hi everybody,

I am working with Lookup Tables in my Message Mapping, so I have a performance issue I think It is because of I am access every mapping execution to the table in the DataBase to recover the table content. I need You help me to resolve that problem, I am wonder if. ¿is there any way to put the table content in memory in order to consume less time in recover the data? ¿Could you suggest other way(not Data base) to handle with the lookup table...maybe in files into PI ?

I am going to really appreciate you help.

Thanks in advance.

Ivan

[SudhirT · Accepted solution]

Hi,

You can use Global Container to fetch data at once and store it in form of some variables in Global Container specially when you are doing repetitive action for same search.

Thanks!

[Former Member]

Hi,

Use Value Mapping Replication method. it will increase the performance coz in this values are stored in JAVA cache and at runtime you don't need to hit the database, the value will be picked up from the java cache itself at runtime.

http://help.sap.com/saphelp_nw70/helpdata/en/13/ba20dd7beb14438bc7b04b5b6ca300/frameset.htm

Regards,

Sarvesh

[bhavesh_kantilal]

Have you considered using either fix values or value mapping?

That might be worth having a look.

Regards

Bhavesh