cancel
Showing results for 
Search instead for 
Did you mean: 

XI Performence issue

Former Member
0 Kudos

Hi,

All

we have IDOC ->JDBC Scenario we need to send 3,50,000 IDOC Data to JDBC Tabel ,Data(3,50,000) Reached to XI ,From XI to Insert in to Tables It is Taking time.

Per minit XI Is Processing 50 Records,It will Take lot of time to process all Records.

Is there any other way to Process more than 50 Records.

Regards

anjan

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hey,

If you are setting Maximum Concurrency to a greater value then even check out in the adavance mode Database Transaction Level as isolation level determines how transactions running in parallel can influence each other.

<b>Cheers,

*RAJ*

moorthy
Active Contributor
0 Kudos

Hi,

Are you using SQL Statements to update the database. If so, instead of SQL statements, call Stored Procedure so that entire message will be sent from XI at a time and then it will process in the Receiving Application system ie Database. Hence you can minimize the connetion time etc,

Before you think of above alternate suggestion, try out with Parameter called Maximum Concurency in the Receiver JDBC channel. for more:

http://help.sap.com/saphelp_nw70/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

btw this is kind of initial load or it will run as daily interface?? If so, it is prefer to re-think about the design of JDBC insert from XI.. If it is once in a while, then it is ok..

Hope this helps,

Rgds,

Moorthy

Former Member
0 Kudos

Hey,

As satish pointed out one way out is performance tuning.

Secondly if you are using a normal idoc to jdbc scenario it will take huge amount of time to process.

You can try this

XI: IDOC bundling - the "trick" with the occurance change

/people/michal.krawczyk2/blog/2005/12/04/xi-idoc-bundling--the-trick-with-the-occurance-change

or try stefan grube Collecting IDocs without using BPM and use a file to jdbc scenario

/people/stefan.grube/blog/2006/09/18/collecting-idocs-without-using-bpm

Check out if they can resolve some issues. In the receiver JDBC adapter do remem to set Disconnect from the database after processing each message.

There have been numerous threads where this issue has been discussed some might help you out.

<b>Cheers,

*RAJ*

*REWARD POINTS IF FOUND USEFULL*</b>

Former Member
0 Kudos

Hi,

The number of records being processed depend on the size of each record. I am not sure if there is any specific setting that can be done to overcome this. however, there are settings that can be done to increase the through put. But these settings will effect the whole env rather than for the specific case. hence i would suggest you give a thought about it before you proceed to perform any change to the system settings.

reward if helpful

Sarath

Former Member
0 Kudos

Anajan,

Check this tuning guide and ask your Basis guys to set the paramters according to this document:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ada5ef-0201-0010-1f8b-c935e444...

Regards,

---Satish