on 07-24-2007 12:01 AM
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
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*
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Anajan,
Check this tuning guide and ask your Basis guys to set the paramters according to this document:
Regards,
---Satish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.